create one access form to enter data into different tables

A

access user 65

I have 12 tables in one access dbl file can you use one form to enter data
into any of the tables, or do you have to make a form for each table
 
R

Rick Brandt

access user 65 said:
I have 12 tables in one access dbl file can you use one form to enter data
into any of the tables, or do you have to make a form for each table

The number 12 raises warning bells. These aren't one table per month are they?
If so, you are going about this all wrong. You should not have multiple tables
with the same structures. It should all be one table with a field that
identifies what is different. Then it is trivial to use one form filtered to
look at any specific set of data.

If that is not your situation then disregard.
 

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

Top