Select vs update Query

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

I'm trying to create a form that I can use to update
individual records. I created a select querty to identify
the record, but I can't seem to update the record
information. the properties of my form are set correctly
so I'm not sure why this is happening. Do I need to do a
command when the form is opened to empty the field of the
existing informaoitn to allow it to be editted? thanks
 
1. (More common) Have you checked whether the Select Query / SQL String is
updateable?

Queries that combine 2 or Tables may not be updateable (depending on the
joins used). Open the Query by itself, i.e. not through the Form, and see
if you can update the data in the DatasheetView of the Query. Also, if you
don't see the "New Record" row, your Query is not updateable.

If this is the case, check Access Help on "Updatable Queries" which shows a
few techniques of converting a non-updateable Queries to updateable.


2. Have you checked the AllowEdits Property of the Form?

If the AllowEdits is set to False, you won't be able to edit any Record.

Also, check the Locked Property of the Controls.
 
Back
Top