Forms and Tables

  • Thread starter Thread starter RichK
  • Start date Start date
R

RichK

Hello All!

A question from an Access Newbie....

I have several tables setup and also have a form. I want the form to contain
text fields that enter data into the different tables. What is the best (and
easiest ) way to accomplish this. I may be missing the obvious so I ask you
experts for some assistance.


TIA!

Rich
 
RichK said:
Hello All!

A question from an Access Newbie....

I have several tables setup and also have a form. I want the form to contain
text fields that enter data into the different tables. What is the best (and
easiest ) way to accomplish this. I may be missing the obvious so I ask you
experts for some assistance.
Click to expand...

A form can only have a single RecordSource. It can either be a table or a
query. If it's a query the query can include data from multiple tables...BUT,
multi-table queries are very often non-editable. And the more tables in the
query, the more likely it will not be editable. So, having a single form make
insertions or updates to multiple tables at once is usually not going to work.

The standard solution is to use forms with subforms so that each form/subform is
only attempting to write to a single table.
 
Back
Top