Select table/query to use when opening a form (Access 2003)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to open a form and select which table/query to use? If
possible, how do I code this? Thanks.

Chai
 
It is possible, but be aware the bound field names will have to be the same
for all tables or queries selected. You would do it in the form load event:

Me.Recordsource = "TableOrQueryName"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Data Source Based On Outcome Of 1
Udating a table 3
Print A Form Double-Sided 6
Disable Text Boxes (Access 2003) 6
Print Form In Access 2003 7
Copy Conditional Formating in Forms in Access 2003 1
Entering New Record In A Form (Access 2003) 2
Dim A Command Button (Access 2003) 3

Back
Top