mercredi 25 mars 2015

Access - Drop Down List Open Form

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