Open a table in a From based on a filter

[turbobeagle]

I want to create a form that will open a table, but not the same table each time. I want the user to be able to choose from a prompt or drop down list which table they want to open in the form. Does anyone have any suggestions to start or can point me in the right direction? Thanks. :roll:

[jya]

Do you want to create a dropdown listing all of your available tables? Or, would you already have another table listing the tables you could open?

To open a table from a dropdown selection, I would add a command button to the form. I would add a line of code in the On_Click event to the effect of

Docmd.open table Me!ComboBoxName