I have an unbound form with 2 combo boxes. The first combo box gives me a list of tables, and their properties. I want the row source for the 2nd combo box to use the table that was chosen in the first combo box. How is this accomplished?
For example:
sql = "SELECT tablename.field1, tablename.field2" & _
" FROM tablename;
how do i set the tablename as the result of the first combo box?
Any suggestions would be helpful.
Thanks,
For example:
sql = "SELECT tablename.field1, tablename.field2" & _
" FROM tablename;
how do i set the tablename as the result of the first combo box?
Any suggestions would be helpful.
Thanks,
