Is there a way that I can have a form in Access show the user a list of the tables that are in Access as a drop down list?
What I want to do is let the user view data based off the actual table it is in.However, also don't want to show ALL the tables, just ones with a name prefix like "Data_*".
I want the user choose the name and then by clicking the bottom can append to a main table .
Thank you very much
What I want to do is let the user view data based off the actual table it is in.However, also don't want to show ALL the tables, just ones with a name prefix like "Data_*".
I want the user choose the name and then by clicking the bottom can append to a main table .
Thank you very much