Creating a from with options that leads to suboptions with search criteria

[jacksparrow]

Hello and thanks in advance.



I am new to forms. My project deals with creating a form that provides 4 options to users, upon clicking any of the option, it will allow a user to enter parameters/search criteria to print a report.

I need help with how to create form that will take user from first form (with 4 options) to another form (with search criteria input)

I currently have this setup by creating a separate form for each of the 4 options and call them using onclick function. However, this opens each form in its own tab.

I want to create something where everything is taking in one form, meaning the search criteria will open up in the same form as where the options are listed. Is this only achievable using VBA?

Any help is greatly appreciated.

[aytee111]

You could use a tab control, one page for each of the forms. The user will then select the page they require.

Or set them visible/invisible during each onclick event. I'm not sure but I think the latter can be done in a macro.

[jacksparrow]

Can it be not done in SubForm? The 4 options open subform upon clicking?

[aytee111]

A subform is just a form which becomes an object on another (parent) form. It does get opened but is displayed when the parent is opened. All you can do is make the subforms visible/invisible, so that in the OnClick event the macro will set three of the subforms to invisible and the selected one visible.

[jacksparrow]

A subform is just a form which becomes an object on another (parent) form. It does get opened but is displayed when the parent is opened. All you can do is make the subforms visible/invisible, so that in the OnClick event the macro will set three of the subforms to invisible and the selected one visible.

Yup that I think will do. Would you be able to help with the event procedure code?

[aytee111]

Sure.

The first question is, how do the users select an option? It is an option group or a textbox or ...? This will determine which event is fired off and where/how the code is done.

[jacksparrow]

Sure.

The first question is, how do the users select an option? It is an option group or a textbox or ...? This will determine which event is fired off and where/how the code is done.

It's command button. I am attaching the database with the forms in talk. As you will see the main form is Form1 with 4 options. The first three options has their own separate forms that I've created.

One method we talked above. The other method I was trying is to bring the elements from separate forms on the main form (Form1) and group them together and hide/unhide them when the appropriate option is selected. This is the method my manager had suggested. Please let me know how it is achievable and thanks for your help!

[orange]

You may get some ideas from this article on Dynamic Reports by Martin Green. He offers a sample database as well.
Good luck.

[aytee111]

I used the subform method - Form2.

[jacksparrow]

I used the subform method - Form2.

Thank you so much! I used your method and showed to my boss. She wanted me to use the other method. After searching online, I end up using the below code to figure it out. We grouped together the elements and tagged the groups. We had 3 groups as you see below in the code. The code below will hide the two groups and unhide the one group that the user had picked as an option.

I appreciate your code. Because of you, now I know how to do it two ways.

Dim ctrl As Control
For Each ctrl In Me.Controls
If ctrl.Tag = "Mbr_Detail" Or ctrl.Tag = "Svc_Month" Then
ctrl.Visible = False


Else: ctrl.Visible = True
End If
Next