#error in Dlookup

[mahavir475]

Dear experts,

I have database for verification of transporter invoice as per their rate contract. This database have six tables

I made table for contract. then I created query with contract table for getting rate of services using Dlookup in verification form. I got desired result in the subform but there is a problem.

Please open attached transport access database, open form "frmGR", We have to enter Transporter, Invoice No. Invoice Date, then in the subform enter GR No., GR Date, Vehicle type, City, Charges come automatically using Dlookup from "qryContractfilter"

The problem is in next "Blank Row" getting #error. I tried NZ(), iif with iserror but no success.

Request you all please give me some solution to get rid of this problem.

thanks in advance

 

[pbaldy]

try

=DLookUp("[Charges]","qryContractFilter","[Vehicle] = " & Nz([Forms]![frmGR]![frmSub].[Form]![Vehicle],0))

 

[pbaldy]

By the way, I moved your thread out of the introductions forum. Welcome to AWF!

 

[mahavir475]

hi, thanks it works perfectly but still getting error in total.

 

[arnelgp]

here is your transport db.

 

[mahavir475]

Thank you very much.
Can we achieve this without VBA Code

here is your transport db.

 

[pbaldy]

hi, thanks it works perfectly but still getting error in total.

Well, your formula:

=Nz(Sum([Charges]),0)

refers to a field that doesn't exist. You can't sum a calculated control. Can you change the source of the subform to a query that pulls the charge amount?