I have a subform base on query. I used a textbox with a control source =
Expand|Select|Wrap|Line Numbers
- =nz(DCount("ref_ID","checklist","[profession_id]=" & [ProfessionId] & "and" & "[passed]= " & True & " and" & "[blockid]='" & [Forms]![block_id]![block_id] & "' "),0)
Actually for me it is not a problem but for my boss it is :S.
He asked me to change it to 0 , "" or anything else then #error.
Any Idea how to do that ? NZ function is not working
CHEERS;
WASSIM S DACCACHE