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.
 
Back
Top