How can I Display data from more than 2 tables in a form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that displays data from 2 tables, when I add another table to
be viewed in the form, I get record lock. In other words, I can not add,
change, or move to another record. But, when I remove the table from the
query, I can qview all record, change them and so on.
 
You are creating an uneditable recordset. The most common reason is that
when you add table 3, you are creating a recordset that has multiple rows in
the query for one or more of the tables. For example, If Table 2 is one to
many to Table 3, then you will see multiple occurances for records in Table
2. You can verify this be opening the query without the form and have a look.

The fix is to create a subform where Table 3 is the recordsource for the
subform.
 
Back
Top