Sub Forms

[feeman]

I have a main form with a field for age it also has 2 sub forms on it
1 sub form always needs to be displayed no matter what, but the other
one is dependant on age. If the age is greater than 25 subform 2 does
not appear, if the age is below 25 subform 2 appear. How can I did
this. speak clearly as still learning to use access.

 

[Ken Snell \(MVP\)]

Use the main form's Current event to test the age value, and then set the
Visibility of that second subform control based on the test result.

 

[feeman]

Use the main form's Current event to test the age value, and then set the
Visibility of that second subform control based on the test result.

--

Ken Snell
<MS ACCESS MVP>






- Show quoted text -

how is this done, i understand the current event bit, what would the
code look like. also how do you set the visibility of the second form
please.

 

[Ken Snell \(MVP\)]

Example code:

Private Sub Form_Current()
Me.NameOfSecondSubformControl.Visibility = (Me.AgeFieldName.Value<=25)
End Sub


--

Ken Snell
<MS ACCESS MVP>