Cannot edit subform

  • Thread starter Thread starter MikeF
  • Start date Start date
M

MikeF

Just created a subform, and cannot make additions or edits.
The Add New Record button is greyed out.

Went to design mode, and hit Allow Additions, Allow Edits, etc.
it's not locked.
Even went to the form properties and put Me.AllowEdits = True in OnLoad and
OnCurrent.

Althougth the main form has Me.AllowEdits = False for safety, until I hit an
Add Record button.

It *was* working properly, ie allowing edits, but now is not.
Understand that doesn't make sense, but ....!

Anyone know what's causing this?

Thanx,
- Mike
 
Just created a subform, and cannot make additions or edits.
The Add New Record button is greyed out.

Went to design mode, and hit Allow Additions, Allow Edits, etc.
it's not locked.
Even went to the form properties and put Me.AllowEdits = True in OnLoad and
OnCurrent.

Althougth the main form has Me.AllowEdits = False for safety, until I hit an
Add Record button.

It *was* working properly, ie allowing edits, but now is not.
Understand that doesn't make sense, but ....!

Anyone know what's causing this?
Click to expand...

Check to see if the subform's Recordsource query is updateable.
 
Just created a subform, and cannot make additions or edits.
The Add New Record button is greyed out.

Went to design mode, and hit Allow Additions, Allow Edits, etc.
it's not locked.
Even went to the form properties and put Me.AllowEdits = True in OnLoad and
OnCurrent.

Althougth the main form has Me.AllowEdits = False for safety, until I hit an
Add Record button.

It *was* working properly, ie allowing edits, but now is not.
Understand that doesn't make sense, but ....!

Anyone know what's causing this?
Click to expand...

Check to see if the subform's Recordsource query is updateable.
 
Followed the directions exactly, but get an error when the form opens.
It doesn't like the following piece of code, and stalls on it ...

4.To initialize the form so it comes up locked, set the On Load property of
your form to:
=LockBoundControls([Form],True)
 
Followed the directions exactly, but get an error when the form opens.
It doesn't like the following piece of code, and stalls on it ...

4.To initialize the form so it comes up locked, set the On Load property of
your form to:
=LockBoundControls([Form],True)
 
Back
Top