ACCESS, HAVE BLANK FORM AND CHOOSE A TABLE OF MY CHOICE

[RUDY WADDE]

I have a client that created 8 databases and can only be viewed in the data
sheet view. I want create a blank form that I can use a pull down to select
anyone of the databases into the form and view and perform any functions that
are attached to the form. Then blank the form so I can open another database
etc.
ACCESS 2000

 

[Arvin Meyer [MVP]]

Use an unbound form without binding any of the controls. Then code
everything using a button click event. Lots of work, but it can be done.

If the tables have the same structure, you can bind to any one of them, then
change the recordsource at runtime.