.AllowEdits

  • Thread starter Thread starter Steve
  • Start date Start date
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
 
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

Similar Threads

Opening Form To Add New Records + View Existing Records 5
Save when editing a record 2
sub forms control change 1
Forcing Current Event to Fire? 3
How do I run this code? 2
Looping through subforms ? 4
Allow Edits to Subform 2
Controlling Allow Edits Property 6

Back
Top