I have a form with a textbox "Text360". The form also contains a subform based on a query "qryCSLWOSCt"
The query contains a value "CountOfReason" that I would like to return to Text360.
If CountOfReason is null, the value returned is 0.
What is the best way to accomplish this?
Here's what I've tried so far:
Text360 = Nz(qryCSLWOSCt!CountOfReason,0)
then I get this message.
"You entered an expression that has no value."
I've also tried this:
If IsNull(DCount("*", "qryCSLWOSCt")) Then Text360 = 0 Else Text360 = qryCSLWOSCt!CountOfReason
this works if there is a value, if not I get this message.
"The value you entered isn't valid for this field."
It appears that a problem appears when the query is blank.