MS Access: Hide and Unhide subform based on drop down in Main Form

Question

Can I hide and unhide a subform based upon the output of a combobox?

Here is what I am attempting to do...

The SchedGenMain_Form (main form) has a combo box called Product_Select_Combo. If Product_Select_Combo is populated with data, I would like the SubProduct_Form to to be visible. If Product_Select_Combo does not have data, I would like it to be hidden.

Also, for another subform... If Product_Select_Combo's data equals "Product 123", then I have another subform (Invoice) that I would like made visible.

Thanks in advance for your help!

Answer 1

In the Design view of your form. Click the Combobox, and go to after_update event.

In there you will be able to add the code for your form

Private Sub ComboBox_AfterUpdate()

    If Me.Combobox.Value = "Product 123" Then
        Forms!SubFormName.Visible = True
    Else
        Forms!SubFormName.Visible = False
    End If

End Sub