Update A Single Subform Using Command Buttons and Multiple Queries

[Madmartigan]

Hello all,

I have searched and searched but haven't been able to find a complete solution to my problem.

I have 5 unique queries and what I would like to do is create 1 form that has 5 buttons (1 per query). This form will also have a subform (datasheet). When a user presses any one of the 5 buttons, the subform/datasheet will populate with the respective query results. My VBA/SQL skill is still very new so if I can accomplish this via macros, that would be preferred.



Any help is greatly appreciated.

[pbaldy]

Me!SubformName.Form.RecordSource = "QueryName"

replacing SubformName with the name of the subform control name.

[pbaldy]

Sorry, that's VBA. If you want to use a macro, it's either SetValue or SetProperty.

[ssanfu]

Create 5 forms based on the 5 queries.
Add 5 sub-form controls on the form. Set each of the sub-form controls visible property to FALSE.

I never use macros so you will have to create the macros... each button should change the associated sub-form visible property to TRUE and set the other 4 sub-form controls visible property to FALSE.


Button 1 : Sets
Sub-form 1 visible property to TRUE
Sub-form 2 visible property to FALSE
Sub-form 3 visible property to FALSE
Sub-form 4 visible property to FALSE
Sub-form 5 visible property to FALSE

Button 2 : Sets
Sub-form 1 visible property to FALSE
Sub-form 2 visible property to TRUE
Sub-form 3 visible property to FALSE
Sub-form 4 visible property to FALSE
Sub-form 5 visible property to FALSE

Button 3 : Sets
Sub-form 1 visible property to FALSE
Sub-form 2 visible property to FALSE
Sub-form 3 visible property to TRUE
Sub-form 4 visible property to FALSE
Sub-form 5 visible property to FALSE

... you get the idea

The subforms are always populated, you just control which subform you want to see.

[Madmartigan]

Thanks guys! I'll give that a shot!