AndyCompanyZ
Registered User.
- Local time
- Today, 11:24
- Joined
- Mar 24, 2011
- Messages
- 223
I have this piece of code but is returning the error "You entered an expression that has no value":
Not sure why this happens. I wrote this more as pseudocode as I'm not sure of the correct syntax and am experimenting. Me.chkFinal is a tickbox inside a option group (I have only one option so far in it, I may add others later) . Can anyone point me to where I can solve this.
Thanks
Code:
Private Sub Frame76_AfterUpdate()
If Me.chkFinal = Yes And Me.ScheduledNumber < Me.CourseMInDel Then
MsgBox "There are less than the minimum amount of delegates scheduled on this event.Please check before finalising"
ElseIf Me.chkFinal.Value = Yes And Me.ScheduledNumber > Me.CourseMaxDel Then
MsgBox "There are too many delegates scheduled on this event. Please check before finalising"
End If
End Sub
Not sure why this happens. I wrote this more as pseudocode as I'm not sure of the correct syntax and am experimenting. Me.chkFinal is a tickbox inside a option group (I have only one option so far in it, I may add others later) . Can anyone point me to where I can solve this.
Thanks