Hello
I have a subform base on query. I used a textbox with a control source =
Each time we add a new record to the subform it works properly unless the last record (I mean the newrecord that it doesn't containt any values)It is #ERROR.
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
I have a subform base on query. I used a textbox with a control source =
Code:
=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
Comment