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
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