subform to main form formula #Error

  • Thread starter Thread starter Revned
  • Start date Start date
R

Revned

hello,

i have this as my records source to one of my text box in my main form.
=[tblCharges subform].Form.sumchargeamt

i set the Child Link :InclusiveInvoiceNo
Master Link fields : InvoiceNumber
it works will, when i scroll on my combo it filters base on InvoiceNumber

the problem is when the i choose a certain inovice number with no records
stored from my subform it gives this result #Error on my text boxes.

is there anyway to handle this?i just want 0 to be displayed in this text
box when no records stored for particular inoicenumber

thanks for any help
 
thank you very much Jeanette Cunningham and June7
I really appreciate your help and kindness

Jeanette Cunningham said:
Hi Revned,
use the function IfFormHasData from this website.

http://allenbrowne.com/RecordCountError.html



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



Revned said:
hello,

i have this as my records source to one of my text box in my main form.
=[tblCharges subform].Form.sumchargeamt

i set the Child Link :InclusiveInvoiceNo
Master Link fields : InvoiceNumber
it works will, when i scroll on my combo it filters base on InvoiceNumber

the problem is when the i choose a certain inovice number with no records
stored from my subform it gives this result #Error on my text boxes.

is there anyway to handle this?i just want 0 to be displayed in this text
box when no records stored for particular inoicenumber

thanks for any help
Click to expand...
Click to expand...
 
Back
Top