adamdaban daban
asked on
ms access fix textbox #Erro
I had this question after viewing Import XML File Into Access Table Using VBA???.
Hi everyone,
I need help,
I have one textbox and I use one function =Nz(DSum("[Total]","Total_ Customer_Q arz","[Cus tomer_ID] = " & [Customer_ID]),0)
so when having records it's showing me correct but when have no record will give to me #ERROR!
Hi everyone,
I need help,
I have one textbox and I use one function =Nz(DSum("[Total]","Total_
so when having records it's showing me correct but when have no record will give to me #ERROR!
ASKER
sorry I'm not understanding your solution
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks it's work
you're welcome ~ happy to help
I see you do have NZ wrapped around the whole thing ... but that is not helping when there is no value in the control