What is the syntax for...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

There's probably a real simple answer to my question, but I'm stuck on this
and can't solve it myself. I have a form with a subform. I'd like to be
able to set the subform's "AllowEdits" parameter to true when a command
button on the main form is clicked. What is the syntax for this?

thanks in advance for the help
 
Sorry, I mis-stated the question. The form has a subform which also has a
subform. What is the syntax to set the "AllowEdits" parameter of the
sub-subform?

rpw said:
Hi,

There's probably a real simple answer to my question, but I'm stuck on this
and can't solve it myself. I have a form with a subform. I'd like to be
able to set the subform's "AllowEdits" parameter to true when a command
button on the main form is clicked. What is the syntax for this?
Click to expand...

I'll answer my own question - the syntax for the above is:
Me.NameOfSubformControl.Forms.AllowEdits = True
 
<<Me.NameOfSubformControl.Forms.AllowEdits = True>>
Nope! No "s" at the end of Form

Question 2 ---
Me.NameOfSubformControl.Form.NameOfSubsubform.Form.AllowEdits = True
 
Paula said:
<<Me.NameOfSubformControl.Forms.AllowEdits = True>>
Nope! No "s" at the end of Form
Click to expand...
Hmmm, maybe we have different VBA? The "s" is there automatically on mine.
A search in the VBA help window for "AllowEdit" will find "AllowEdits
Property"
Question 2 ---
Me.NameOfSubformControl.Form.NameOfSubsubform.Form.AllowEdits = True
Click to expand...

Intellisense will autofill up to the 'dot' after the first "form" entry.
NameOfSubSubForm is not in the intellisense list, so I figured I was headed
in the wrong direction. But, I tried it (after reading your post) and it
does work, so... Thanks!
 
Arrgg! Sorry Paula - apparently my brain is not functioning correctly. You
are absolutely correct - there is no 's' at the end of 'Form'. My mistake.
:-(
 
Back
Top