I have a list box on a form in which it's value is based on an option group. I would like to open a form based on that value. For example option 2=long evaluation, option 3=short evaluation, so if the value in the list box is 2 I want to open frmLongEvaluation when I double click on that record in the list box. I kind of got some help regarding this and here is the code I have so far:
Private Sub ListEvaluation_DblClick(Cancel As Integer)
Select Case Me.Evaluation
Case 2 'Long Evaluation
DoCmd.OpenForm "frmEvalLong", , , , , , , Me.SessionID
Case 3 'Short Evaluation
DoCmd.OpenForm "frmEvalShort", , , , , , , Me.SessionID
End Select
End Sub
I get an error that states it can't finde Me.Evaluation(option group)
Any ideas would be great
Thanks,
Private Sub ListEvaluation_DblClick(Cancel As Integer)
Select Case Me.Evaluation
Case 2 'Long Evaluation
DoCmd.OpenForm "frmEvalLong", , , , , , , Me.SessionID
Case 3 'Short Evaluation
DoCmd.OpenForm "frmEvalShort", , , , , , , Me.SessionID
End Select
End Sub
I get an error that states it can't finde Me.Evaluation(option group)
Any ideas would be great
Thanks,