Form for multiple tables

  • Thread starter Edward Jones (Eddie)
  • Start date
E

Edward Jones (Eddie)

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.
 
K

Klatuu

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