.AllowEdits

S

Steve

I have a form with several related sub forms. When the
form is opened the form is set:

AllowEdits=Fasle
AllowAdditions=False
AllowDeletions=False

When the user pushed a button, this code runs:

Me.AllowEdits = True
Me.AllowAdditions = True

The text boxes on the main form become available for data
entry, but the sub forms are still unavailable. Any help?

Thanks
 
K

Ken Snell

Each subform has its own such properties. You'll need to change their
properties' values as well:

Me.SubformControl.Form.AllowEdits = True
Me.SubformControl.Form.AllowAdditions = True

where SubformControl is the name of the subform control (the control that
holds the subform, which may or may not be the same name as the control's
SourceObject).
 

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