access form won't accept edits

  • Thread starter Thread starter Puzzled
  • Start date Start date
P

Puzzled

For some reason my access form won't allow me to edit data. I've had this
problem before, but forgot how I fixed it.
 
For some reason my access form won't allow me to edit data. I've had this
problem before, but forgot how I fixed it.

The most common reason is that the form's Recordsource is a query which isn't
updateable. Open the form in design view; view its Recordsource property;
click the ... icon by it to open a query design window. If you open the query
as a datasheet, does it have a *> blank new record at the bottom? If not, it's
not editable.

You could open it in SQL view and post the SQL text here if you'ld like help
finding out why it's not.
 

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

Back
Top