Copy a form and associate w/ new table

  • Thread starter Thread starter Craig Robinson
  • Start date Start date
C

Craig Robinson

I have created a database in which I use a form (form 1)
to enter data into a table (table 1). I have copied the
structure of table 1 into a new table (table 2) and now I
would like to copy the structure of form 1 into a new form
(form 2) associated with table 2. I copied form 1 into
form 2 no problem, but now I can't figure out how to
associate form 2 with table 2.
 
I have created a database in which I use a form (form 1)
to enter data into a table (table 1). I have copied the
structure of table 1 into a new table (table 2) and now I
would like to copy the structure of form 1 into a new form
(form 2) associated with table 2. I copied form 1 into
form 2 no problem, but now I can't figure out how to
associate form 2 with table 2.
Click to expand...

I have to question this entire process. Having two identically
structured tables in your database is generally A Bad Idea. If you
have two categories of data you're almost always better off just using
*one* table, with *one* form; add a field to the table to identify the
category, and use a criterion to select which set of data to display
on the form.

That said... open the second Form in design view; view its Properties;
and find the Recordsource property (first on the Data tab). Change
this to the name of the new table.
 
Back
Top