how do I change the table from which a form obtains data

J

jo

I have a form that I have set up, but I would like to re-create it several
times and change the table that each copy gets data from.
EG Table 1 feeds Form A. I want to copy this form to create form B but it
currently gets data from table 1, so I need to change it so that it now gets
data from table 2.
That's probably clear as mud but hopefully someone can help me!
thanks
 
A

Al Campagna

Jo,
If all the tables have exactly the same fields, you just need to change
the Form's RecordSource.
Copy the form to another name, and change the RecordSource table, or
more usually, a query against the new table.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Top