Redirecting data entry form to new table

[rhybeka]

Hi all,

I'm fairly new to Access so I'm hopeful this is an easy question. I have a data entry form I've created to keep track of all support requests that come into me with fields that auto populate with location, etc.Currently this form is filling in a table called 2014 Issues and Updates and I'd like to point it to a new table called 2015 Issues and Updates. Is this an easy lift and shift that I'm not thinking of, or do I need to go in and remap all the fields in my form to the new table? Thanks!

Becky

 

[Joe4]

If all your field names are the same between the two tables, this should be pretty easy.

- Open the Form in Design View.
- Click on Properties
- Go to the Data tab
- The first Property listed is "Record Source". Change the name of the table you want it linked to here.

 

[rhybeka]

If all your field names are the same between the two tables, this should be pretty easy.

- Open the Form in Design View.
- Click on Properties
- Go to the Data tab
- The first Property listed is "Record Source". Change the name of the table you want it linked to here.

Thanks Joe! That did the trick