When check box is checked, more fields appear

[lonesoac0]

Hello all,

I have a check box named "Flashes of light?" I would like to show more fillable fields when that field is checked. How do I do that?

Thank you.

[Eljefegeneo]

Well, not knowing what you have on your forms, you probably have to do two things.
Using the OnCurrent event, set the visibility of the other fields with something like this:

If Me.[Flashes of Light] = True then
Me.Field1.visible = True
All the other fields in the same way
Else
Me.Field1.visible = False
Etc.
End if

And in the after update of [Flashes of Light] enter the same code. Actually you can avoid doing it a second time by writing the code in a public sub and then running the code in the Form OnCurrent Event and the checkbox AfterUpdate Event.

i.e.

Public Sub Flashes()
If Me.[Flashes of Light] = True then
Me.Field1.visible = True
All the other fields in the same way
Else
Me.Field1.visible = False
Etc.
End if
End sub

Then in the OnCurrent event type
Flashes
And in the AfterUpdate of the check box type
Flashes