fields from multiple tables

[Guest]

I keep getting the message "recordset is not updateable" when I try to create
a form using fields from 3 or more tables. There is no problem if the form
uses fields from 2 tables. Same problem exists if I create the form using
the fields from 2 tables and then create a text box whose control source is
from a field in a third table. How can I make a form based on 3 or more
tables that is updateable? I am using Access 2000. Thanks.

 

[Sandra Daigle]

The problem is not with the number of tables - it is with the type of joins
and/or grouping in the query. Take a look at the following to see some of
the reasons why your query may be read only:

Online help - in Answer wizard type the following:
"When can I update data from a query?" - open the article by the same name.

ACC2000: How to Edit Records in Related Tables in a Microsoft Access
Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;304474