Cannot edit subform

[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

 

[MikeF]

Thanx, that looks like the solution.
Will give it a go.

 

[MikeF]

Thanx, that looks like the solution.
Will give it a go.

 

[John W. Vinson]

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?

Check to see if the subform's Recordsource query is updateable.

 

[John W. Vinson]

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?

Check to see if the subform's Recordsource query is updateable.

 

[MikeF]

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)

 

[MikeF]

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)