show subform based on toggle

  • Thread starter Thread starter papa jonah
  • Start date Start date
P

papa jonah

I have a form that includes a toggle switch. Depending on which option
is selected, I want a subform to be displayed. I do not care if the
subform is there but not visible and becomes visible, or if the toggle
actually causes it to open. I have not figured out how to do this with
either code, macro, or whatever the other option is.
Any help would be appreciated.

TIA
Papa
 
In the click event of your toggle button try this code
If Me.SubFormName.Visible = True Then
Me.SubFormName.Visible = False
Else
Me.SubFormName.Visible = True
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subform option group not working 5
Subform Datasheet Total Row 3
How to get a Toggle Button to work 2
SetValue Subform Records 1
Toggle Button 1
Toggle Button not refreshing 1
Access Reference Subform's Control 0
Display subform total 1

Back
Top