Change reports to reference a new table.

[badmem]

I have a table called Q1 which forms and reports use. I've now created a new table Q2 which uses the same data structure. Is there a way to change the forms and reports to reference table Q2 instead of Q1 without manually changing all of the fields?

Thank you

[RuralGuy]

If the field names are the same then just change the RecordSource of the report/form. It will work.

[orange]

Further to Allan's advice, which answers your direct question, I suggest you use more meaningful names for your tables. Q1 and Q2 are just examples, right?

[badmem]

Thanks for your replies. Yes the names are examples.

Does this work with queries as well? I have a query that links the Q1 table to another "Department" table. As you can tell I'm a novice with Access. At the moment I'm copying the Q1 query putting the new Q2 table into the design view and linking the Q2 table to the department table. I then manually change the references from Q1 to Q2. Finally I delete the Q1 table from the query. Is there an easier way to do this?

Thank you.

[RuralGuy]

A form can not tell the difference between a table and a query.