Option Box (1 Viewer)

Gismo

Registered User.
Local time
Tomorrow, 01:45
Joined
Jun 12, 2017
Messages
1,298
Hi All,

Need some help please
I need top open one of 3 forms depending on the option selected in the option box but only after other criteria such as customer has been selected. i have a field in the form indicating the value of the option box after it has been selected

below is my code. i get an error that field '1' can not be found

Code:
Private Sub View_Click()
Select Case Me.OptionBoxSelection
    Case 1
        DoCmd.OpenForm [Edit - Spares]
    Case 2
        DoCmd.OpenForm [Edit - Aircraft]
    Case 3
        DoCmd.OpenForm [Edit - Training]
   
 End Select
End Sub
 

CJ_London

Super Moderator
Staff member
Local time
Today, 23:45
Joined
Feb 19, 2013
Messages
16,553
your formname needs to be surrounded with quotation marks
 

Users who are viewing this thread

Top Bottom