form/subform text box interactions

  • Thread starter Thread starter Lauren B
  • Start date Start date
L

Lauren B

How can I code my form so that when checkbox 1 (located on Form1) is
clicked, any information entered in textbox1 (located on Subform 1) is
completely cleared?

Thank you in advance for any assistance.

LB
 
Lauren said:
How can I code my form so that when checkbox 1 (located on Form1) is
clicked, any information entered in textbox1 (located on Subform 1) is
completely cleared?

Thank you in advance for any assistance.

LB
Click to expand...

In the AfterUpdate event of the CheckBox...

Me.NameOfSubformControl.Form.textbox1 = Null

I used "NameOfSubformControl" because there is no guarantee that the name of
the subform *control* is the same as the name of the form within it and your
post could be talking about either or both when you wrote "Subform 1". Make
sure that you put the name of the control in the statement.

If you dragged and dropped the subform to create it or used the wizard, then
the control and form within likely do have the same name.
 
Back
Top