Form Suddenly Became Non-Editable?

P

(PeteCresswell)

No nibbles on comp.databases.ms-access, so here it is:
=================================================================

Got a data entry form with many fields on it.

Suddenly all fields have become non-editable.

The form's .RecordSource is editable.

All I can think of is that I have fat-fingered some property that
is crucial to the form's being editable.

Form Props that I can think of:

..AllowEdits = True
..RecordsetType = Dynaset
..RecordLocks = NoLocks

Field Props:

..Locked = False
..Enabled = True


Can anybody think of something else?
 
P

(PeteCresswell)

Per (PeteCresswell):
Can anybody think of something else?

FWIW, I found a workaround.

The form is based on an empty "Work" table.

Seems like the form has somehow been automagically creating a
single record in that table when the form is opened and it had
stopped doing so - even though .DataEntry=False.

The fields became non-editable when there was no underlying
record to support the .ControlSources

I added a few lines of code in Form_Open to insert an empty
record and all became well.
 

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

Top