Simple If Statement not working ?

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

The Flag control is my table called Time and it is set to Yes/No with a
format of True/False
On the form it is a checkbox as well. i.e. Checked or not!
Why does this not work?

If ([Flag]) = True Then
MsgBox "Record has been flagged, Please check notes"
End If
 
Dave

You need an event to trigger this statement something like this

Using the afterupdate event

Sub flag_afterupdate()
If ([Flag]) = True Then
MsgBox "Record has been flagged, Please check notes"
End If
End if

Allan Murphy
Email: (e-mail address removed)
 
It is in the On Current Event of the form

GoodGirl said:
what event/procedure is this code in?

Dave Elliott said:
The Flag control is my table called Time and it is set to Yes/No with a
format of True/False
On the form it is a checkbox as well. i.e. Checked or not!
Why does this not work?

If ([Flag]) = True Then
MsgBox "Record has been flagged, Please check notes"
End If
Click to expand...
Click to expand...
 
Back
Top