subform to main form formula #Error

[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

 

[Jeanette Cunningham]

Hi Revned,
use the function IfFormHasData from this website.

http://allenbrowne.com/RecordCountError.html



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Revned]

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

Hi Revned,
use the function IfFormHasData from this website.

http://allenbrowne.com/RecordCountError.html



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

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