Cannot edit data from form

  • Thread starter Thread starter Sharyn
  • Start date Start date
S

Sharyn

I have created an edit form to edit data from a table.
The form is based on a query. It does not allow me to
edit the records in any way. The form opens from a
command button, and I changed the button to run an
openform macro with the edit property, but still no
luck. Any ideas on what is preventing the editing of
records?
 
Not all queries are updatable. If you open the query itself in datasheet
view, can you edit the data there? Is there a blank new record at the bottom
of the datasheet? If not then you have created a non-updatable query.
 
Thanks Andrew :) I'll check on that
-----Original Message-----
Not all queries are updatable. If you open the query itself in datasheet
view, can you edit the data there? Is there a blank new record at the bottom
of the datasheet? If not then you have created a non- updatable query.




.
Click to expand...
 
Back
Top