Simple If Statement not working ?

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
 
A

Allan Murphy

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: [email protected]
 
D

Dave Elliott

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