Querry does not allow to add records

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

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top