How can I change the table an Access form is connected to?

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

Guest

I exported a form to another database and want to use a table in that
database as the source for the fields in the form. I can get a new form
created by a wizard to recognize the table in the new database, but for some
reason I cannot figure out how to get the form I imported to use that table.
 
I exported a form to another database and want to use a table in that
database as the source for the fields in the form. I can get a new form
created by a wizard to recognize the table in the new database, but for some
reason I cannot figure out how to get the form I imported to use that table.
Click to expand...

Set the Form's RecordSource to the new table.
 
Open your form in design mode. If the form properties go to the record
source property and browse for the table you need. You will need to check
each control, as well, to be sure it has it's control source property set
correctly
 
Back
Top