Querry does not allow to add records

L

Lana

Hi all,

I got some very confusing situation. As developping my DB, at some point i
noticed that i cannot add records to some forms and cannot edit others.

For example the querry "Corr" works all right, but the forms based on it -
cannot add new records (all though it worked fine before and i didnt change
any form settings to prevent data entry).

Can anybody give me any hint what could be the reason of that?

Thank you.
Lana
 
O

Ofer Cohen

Hi Lana,
It usually happen when you create a query with more then one table, the join
between the two tables, and the fact that the query return fields from more
then one table doesnt allow adding more records, or editing the existing one.

This is why its better to base the form on one table, and create a sub form
for the other tables if they are used for data input.
If the other tables are use for information only, then use DLookUp or
recordSet to return this values.
 
Top