D
Didier Morandi
Hi all,
I do not succeed to get a null value via the Nz function on a subform field when
that subform is *not* called due to lack of data to call it.
I explain.
In a form, I process invoices. If for a Customer, there are credit notes, I want
to subtract the total amount of credit notes to the total of invoices to give a
net debit to the Client.
If there are, I get my values ok and Bob is my uncle. If there are no, I get an
error in the following expression:
total_credit =Nz([subform_credit].report!Total;0)
I expected to get a null value when there are no credit notes, as in that case
the subform_credit routine is not called, but all I get is #ERROR# instead of "0".
What do you think?
Many thanks,
D.
Toulouse
I do not succeed to get a null value via the Nz function on a subform field when
that subform is *not* called due to lack of data to call it.
I explain.
In a form, I process invoices. If for a Customer, there are credit notes, I want
to subtract the total amount of credit notes to the total of invoices to give a
net debit to the Client.
If there are, I get my values ok and Bob is my uncle. If there are no, I get an
error in the following expression:
total_credit =Nz([subform_credit].report!Total;0)
I expected to get a null value when there are no credit notes, as in that case
the subform_credit routine is not called, but all I get is #ERROR# instead of "0".
What do you think?
Many thanks,
D.
Toulouse