Cannot edit data from form

[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?

 

[Andrew Smith]

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.

 

[Sharyn]

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.




.