How to make a subform appear and disapear

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

Guest

Hi,

I would like to have a subform in a form that would appear with the
selection of a condition.

example: A customer will provide a primary address in the main form. They
will have an option of entering a secondary/mailing address. If they select
the secondary address option, I want the secondary form to appear.

I will appreciate any help.

-Gus
 
On the After update event of the check box where the user define if he wants
a secondary address you can write the code

Me.SubForm.Visible = (Nz(Me.CheckBoxName,False) = True)

If you navigate between records, then add this code to the OnCurrent event
of the form.
===================
In my answer I asumed you are using a check box, but if you are using an
option button then use the OnClick event
 
Back
Top