P
Paul
hi...
first of all thank you for the help...
my problem is, I have statement of account form and I have sub form for the
invoices.. (Using Access) in the sub form there is unbound control to sum the
invoices total and in the statement form there is another unbound control its
source set to:
control source = forms![invoices_subform]![SuminvoicesTotal]
when there is no invoices in the sub form (and that depends on their date)
then the control =#Error what i want to know is, how i can set the value of
this control to 0 in case of no invoices, where i don't want it to show up as
#Error. hope you can help me for this,
thanks in advance.
first of all thank you for the help...
my problem is, I have statement of account form and I have sub form for the
invoices.. (Using Access) in the sub form there is unbound control to sum the
invoices total and in the statement form there is another unbound control its
source set to:
control source = forms![invoices_subform]![SuminvoicesTotal]
when there is no invoices in the sub form (and that depends on their date)
then the control =#Error what i want to know is, how i can set the value of
this control to 0 in case of no invoices, where i don't want it to show up as
#Error. hope you can help me for this,
thanks in advance.