AndyCompanyZ
Registered User.
- Local time
- Today, 00:58
- Joined
- Mar 24, 2011
- Messages
- 223
Still more VBA solving for me to do. I can't work out why I am getting a type mismatch on this piece of code:
The combobox has 3 options which are
On Hold [1], Confirmed [2] , Cancelled [3]
The bound column is 1 which is the number but I'm wondering if that is where the problem is or is it that the control source is EventStatus which is a table field. I have tried changing the combobox name but same thing happens I'm wondering if the control source should be the combobox or not.
Code:
Private Sub EventStatus_Change()
If (Me.EventStatus.Value = 3) And (Me.ScheduledNumber > 0) Then
MsgBox "There are already delegates scheduled on this event. Please inform the delegates and reschedule", VbMsgBoxStyle = vbOKOnly
End If
End Sub
The combobox has 3 options which are
On Hold [1], Confirmed [2] , Cancelled [3]
The bound column is 1 which is the number but I'm wondering if that is where the problem is or is it that the control source is EventStatus which is a table field. I have tried changing the combobox name but same thing happens I'm wondering if the control source should be the combobox or not.