access form won't accept edits

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.
 
D

dsebaucom via AccessMonster.com

Puzzled said:
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.
Click to expand...

Go to the Properties window of your form and then go to the "Data" tab. There
is an option for "Allow Edits" on that tab.....or it might be the "Data
Entry" option.
 
J

John W. Vinson

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.
Click to expand...

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.
 
Top