You could try something like this in the on click event of a Cmd Button or in the after update event of the combo box.
This method is ok if you only have a small number of values in your combo box
If Combo0 = "the 1st value selected from the combo goes here" Then
DoCmd.OpenForm "The name of your form goes here", acNormal
ElseIf Combo0 = " the 2nd value selected from the combo goes here " Then
DoCmd.OpenForm " The name of your form goes here ", acNormal
Else
DoCmd.OpenForm " The name of your form goes here ", acNormal
End If
Hope this is clear enough
Good luck
Matthew
