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

  • Thread starter Thread starter jo
  • Start date Start date
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
 
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."
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
DELETE FROM a table WHERE... 1
How to Populate Data from a table to another 0
Record-Locking remains open after closing 0
Same record/Primary key in multiple tables 0
Please help - I need to separate data to two tables using one form. 0
Pulling data from a linked SQL table 2
update data in table through form 3

Back
Top