TextBox dcount function

[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?

 

[ruralguy via AccessMonster.com]

How about: If Me.Text68 = "0" Then

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?

 

[Ian]

nope, tried = "0" too.

How about: If Me.Text68 = "0" Then

 

[ruralguy via AccessMonster.com]

Try the UnLoad event. The control may already be gone by the Close event.

nope, tried = "0" too.

How about: If Me.Text68 = "0" Then

[quoted text clipped - 12 lines]