I
Ian
I'm using the following controlsource in textbox68 to return a count from a
query to a form.
=(DCount("apptID","qry_cntactappt","clientid=forms.frm_client.clientid"))
Then OnClose of the form
If Me.Text68 = 0 Then
MsgBox ("text")
.........
If also tried = Is Null, Is Null etc.... but when the value is zero in the
dcount the IfThenElse statement won't recognize it.
any suggestions?
query to a form.
=(DCount("apptID","qry_cntactappt","clientid=forms.frm_client.clientid"))
Then OnClose of the form
If Me.Text68 = 0 Then
MsgBox ("text")
.........
If also tried = Is Null, Is Null etc.... but when the value is zero in the
dcount the IfThenElse statement won't recognize it.
any suggestions?