Please be gentle, i'm new to access but I'm trying to create a down down list that opens forms. I've done a fair bit of Google searches and not really found anything.
On my ComboBox on both "After Update" and "On Change" I have tried the below code.... Both with and without data in my drop down list.
Private Sub Combo1_AfterUpdate()
Select Case Combo1.Value
Case "Menu1"
DoCmd.OpenForm "Form1"
Case "Menu2"
DoCmd.OpenForm "Form2"
Case "Menu3"
DoCmd.OpenForm "Form3"
End Sub
I have also tried;
DoCmd.OpenForm Combo1.Value
and adding my form names in the ComboBox but that doesn't work either.
Thanks in Advance.
.Lee
Aucun commentaire:
Enregistrer un commentaire