Updating records in a form

J

JP Martinez

Hi I have a form which is generated and updated from a query - but the
problem I have is that the records are not updatable.

Any ideas

thanks

-Pierre
 
V

Van T. Dinh

1. Check the Query / SQL String and see if you can update the data. If the
Query is not updateable, the Form will behave the same.

If the Query is not updateable, check Access Help on "Updatable Queries".

This is the most likely problem.

2. If the Query is updateable and the Form is not:

* Check the AllowEdits / AllowAdditions Property of the Form.
* Check the Enabled and Locked Property of the Controls on the Form.
 

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

Similar Threads

Updating in a Form with a Query assigned to the Form 3
Recordset Not Updatable 2
Skip Records on a Form 2
Automatically fill in some fields in data entry form 1
Query Parameter using multiple options 0
Global entry of records 4
Skip Records in a Form 2
blinking form afterupdate 2

Top