Generate A Function Through Access

I have a talbe called LOOP in access. The fields in it ar appl,sales_table,title_code,and passalong.

From this table i want to autogenerate sql and run them in a vb function through access.

My first step was crating the sql. I did it using this query.


SELECT "DOCMD.RUNSQL "&"'"&"SELECT tsr,title "&title_code&" ord_time from "&sales_table&"'"

This generates the following vb command:
DOCMD.RUNSQL "SELECT tsr,title,q2_title,ord_time from appl_sales"

The genrated sql will be a insert into query but this is just an example.

Now this will give me the sql that i want. But I have no idea how to get that into a function.

Basically say it generates 10 different vb commands i need that to run as one function. Is there a way to do this through Access and VB.

Any help would be greatly appreciated.

Thanks