data entry form based on a query

[Guest]

I have a data entry form (users enter comments) that is based on a query.
Query is designed using one imported table and 2 linked tables. Users cannot
enter comments in this form design. If I import one of the linked tables,
users have no problem entering data via this form. How can fix this problem
so I don't have to import that table. I would rather have it linked as the
same table is used in multiple databases.

 

[Brian Bastl]

Monia,

the problem isn't whether the tables are linked to or reside in you current
database; the problem is that you're joining 3 tables as the recordsource
for you form. The recordsource for you form should be a table or a query
based on a table, with perhaps one joined table.

Brian

 

[Guest]

Any suggestions how can I fix it?

Main table with comments has Client ID and other fields related to client.
2nd table has Client ID with RCA ID (user entering comments). 3rd table has
RCA ID and RCA Name. Form displayes info from Client table and RCA Name from
the 3rd table.

When Client - RCA table is imported. The same form based on 3 queries (based