Opening a subform by selection in a combo box? (1 Viewer)

[Ketcham488]

I have a form that contains a form (Contain business data) and a then a sub form that hold the companies history of donations. BUT I also have another forms that hold miscellaneous data that I would like to look at also in the sub form area.

I want to select the sub form by a combo box to show the "sub forms"I want to look at by selecting a menu from a combo box. Thank you in advance!

I have worked with Access for years but some reason the combo box has always been difficult for me to completely understand.

 

[madefemere]

Hello,

Why don't you use tabs control with each sub form that you want.

Another way is to manage the visibility property of your sub-forms at AfterUpDate evenement of the combobox, a code like :

Sub Combo_AfterUpdate()
Select Case Combo
     Case 1
          Me.SFHistory.Form.Visible = True
          Me.SFNumber1.Form.Visible = False
          Me.SFNumber2.Form.Visible = False
     Case 2
          Me.SFHistory.Form.Visible = False
          Me.SFNumber1.Form.Visible = True
          Me.SFNumber2.Form.Visible = True

......
End Select
End Sub

Good continuation