Entering data on forms

[Amy Martin]

I've set up a form that uses data from 3 different
tables, and I'm now unable to enter data in the form or
change existing data. I can do it in the table but not
the form. Any ideas about what I need to do? Thanks!

 

[fredg]

I've set up a form that uses data from 3 different
tables, and I'm now unable to enter data in the form or
change existing data. I can do it in the table but not
the form. Any ideas about what I need to do? Thanks!

If your form uses data from 3 tables, you are using a query as the
form's Record Source. Some queries are not up datable.
Open the query and see if you can edit it there. Probably not.

See Access help.
Click on Help + Answer wizard.
in the Search box, type:

When can I update data from a query?

Follow the links.

Also ....
See microsoft Knowledgebase article:
328828 'INFO: Troubleshooting Errors That May Occur When You Update
Data in Queries and in Forms