This must be an easy one, but I am having trouble.
Can someone help me how to populate a combo box with table names (I have like 50 tables in my database) and then have user pick an item from the como box list and use that item (table name) in a select query? The combo box contains two columns, the bound column is the actual table name and the second column is the more descriptive name for table name so that user can understand.
After picking an item (i.e selecting a table name, say Table_A) from the list, I want to use that table name (Table_A) in a select query. I am having trouble with syntax, I would appreciate if someone can help me please.
Shan.
Can someone help me how to populate a combo box with table names (I have like 50 tables in my database) and then have user pick an item from the como box list and use that item (table name) in a select query? The combo box contains two columns, the bound column is the actual table name and the second column is the more descriptive name for table name so that user can understand.
After picking an item (i.e selecting a table name, say Table_A) from the list, I want to use that table name (Table_A) in a select query. I am having trouble with syntax, I would appreciate if someone can help me please.
Shan.