access form won't accept edits

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.

Puzzled wrote:
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.

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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200910/1

On Fri, 30 Oct 2009 07:56:04 -0700, Puzzled
wrote:

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

John W. Vinson [MVP]