Form for multiple tables

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

Guest

I have a database program that has a create table querry. I have a form for
one of the table made from the querry and i want to see if there is an easy
way i can allow users to select the table and use that form. Can i just set
the Record Source to be the name of an input field. All field names are the
same in the tables. Thank you.
 
Yes you can. When the user selects a table, use the selection to set the
form's Record Source property. I might suggest trying the After Update event
of the control that gets the table name.
 

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

Sharing only forms, not tables 2
Data entry for a table from a form 1
Table in Access Form 3
Add new record to related table and show data on form 2
Code in a Form 7
Creating Checkbox Fields For Every Record 0
Code in Forms/Querry 1
Access Form Refresh 1

Back
Top