brickelldb
Registered User.
- Local time
- Today, 12:42
- Joined
- Mar 9, 2009
- Messages
- 70
Hello. I'm trying to use the value in a text box on a form as the table name in a query.
Example
Form Name: Frm_Module1
TextBox Name: text500
I want to use the value in text500 as the tablename in this query:
SELECT [tablename].Field1, [tablename].Field2, [tablename].Field3
FROM [tablename];
Any help is GREATLY APPRECIATED. I have been googling for three hours. :banghead:
Example
Form Name: Frm_Module1
TextBox Name: text500
I want to use the value in text500 as the tablename in this query:
SELECT [tablename].Field1, [tablename].Field2, [tablename].Field3
FROM [tablename];
Any help is GREATLY APPRECIATED. I have been googling for three hours. :banghead: