N
NYCMoreOn
OKay, I have been beating my head up against the wall for the past 4
days trying to get this to work... I have a form with a subform
(default is hidden), the idea is to be able to browse a resource
database OR, should you choose, search the database by criteria you
set. When you hit the "Search Resources" button on the main form, the
subform becomes visible. I got this to work fine use the following:
Private Sub Search_Resources_Click()
Me!SearchForm.Visible = Not Me!SearchForm.Visible
End Sub
With the subform visible a user can define his criteria and hit
submit...fine. However, I ahve built a command button on the subform
to allow the user to exit out if he/she decides they do not want to
search - essentially hiding the subform again.
The problem I'm having is finding the right code to make a subform
invisible from a command button ON the subform itself.
I know I'm overlooking something totally simple. Can someone please
point me in the right direction. Thanx
days trying to get this to work... I have a form with a subform
(default is hidden), the idea is to be able to browse a resource
database OR, should you choose, search the database by criteria you
set. When you hit the "Search Resources" button on the main form, the
subform becomes visible. I got this to work fine use the following:
Private Sub Search_Resources_Click()
Me!SearchForm.Visible = Not Me!SearchForm.Visible
End Sub
With the subform visible a user can define his criteria and hit
submit...fine. However, I ahve built a command button on the subform
to allow the user to exit out if he/she decides they do not want to
search - essentially hiding the subform again.
The problem I'm having is finding the right code to make a subform
invisible from a command button ON the subform itself.
I know I'm overlooking something totally simple. Can someone please
point me in the right direction. Thanx