Hello,
Is there a way that I can run a query using a variable in a
form?
I have several tables:
TblA
TblB
TblC
...
I have a combo box namely, TableName, which user can browse and select whichever table that want to query with.
What I want is, create a single query (instead of multiples queries for each table) and get the table name to be query through the form.
For instance:
"SELECT * FORM FORMS![MYFORM]![TableName]
How could I do that?
Please shed some light of this!
Thanks a bunch!
ciel220
Is there a way that I can run a query using a variable in a
form?
I have several tables:
TblA
TblB
TblC
...
I have a combo box namely, TableName, which user can browse and select whichever table that want to query with.
What I want is, create a single query (instead of multiples queries for each table) and get the table name to be query through the form.
For instance:
"SELECT * FORM FORMS![MYFORM]![TableName]
How could I do that?
Please shed some light of this!
Thanks a bunch!
ciel220