Thank you! That worked.
For anyone else running into this issue here is the code I used:
Private Sub Toggle84_GotFocus()
Me!frm_qry_mysubform.SourceObject = "frm_qry_myqry" 'sets source of subform to desired form
Me.frm_qry_mysecondsubform.Visible = False 'makes other subform invisible...
Hi Everyone,
I have a main form and a subform. The subform pulls data from a password protected database, each user has their own username and password. I Have the subform set so that it is not visible on the load of the main form but a toggle button relveals it using vba code. The problem is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.