I must be not doing something right. I've got a combo box listing values from a table. Each value corresponds to a different form. When the user makes his selection he presses a button that opens the appropriate form based on which value was selected.
Here's where I started:
Private Sub Command8_Click()
Dim stForm1 As String
Dim stForm2 As String
Dim stForm3 As String
Dim stForm4 As String
stForm1 = "EngForm"
If [Me.combo5.text] = "Engineering" Then
DoCmd.OpenForm stForm1
Else
End If
End Sub
Seems like it should work to me but I'm somewhat of a beginner.
Start Free Trial
