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

 

[Dale_Fye via AccessMonster.com]

Change AllowEdits to True on the main form. Does that resolve the issue?

I rarely set AllowEdits to False, because it prevents just about everything.
Instead, I use some code that I got from Allen Browne's web-site (
http://www.allenbrowne.com/ser-56.html) to lock and unlock specific controls.

HTH
Dale

 

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

 

[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)