Multiple similar Tables in you database, is it possible to run queries etc by pre selecting.....

Hi,

If I understand you correctly you want to use/select different Sharepoint lists as source of queries and forms by choosing them in a "menu screen" = form?

If yes, then you could create a form with e.g. a list box or combo box with the names of the Sharepoint lists, select one from the list and write/execute VBA code in the After Update event of the list/combo box that changes the SQL text (especially the FROM clause) of the queries you want to use directly or as record source of forms.

Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK