nz function problem-query to form

[southbender]

I am using the nz function in my queries. The function works at that level.
However, when I try to open the form it won't allow me to. If I take out the
nz function everything works fine.

Any suggestions

 

[Allen Browne]

Could be an issue with the data type. Try an IIf() expression instead.

More details and example:
http://allenbrowne.com/QueryPerfIssue.html#Nz

 

[BruceM via AccessMonster.com]

Details, please. In what way are you not allowed to open the form? Do you
get an error message, or what exactly? Is the form bound to the query? How
are you using Nz in the query?