Display value from table on form (conditionally)

[micruys]

I want to display the value for VATAmountGBP where the TaxCode is AR from tblSalesSummary on a form. So I gave the following in the Countrol Source of the box in which I would like to display the record:

=DLookUp([VATAmountGBP];[tblSalesSummary];[TaxCode]="AR")

I always get the #Name? error when I display the form...

What am I doing wrong?

Many thanks in advance

 

[ZmrAbdulla]

 =DLookup("[VATAmountGBP]" , "[tblSalesSummary]" , "[TaxCode]= 'AR'")

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[PHV]

Perhaps this ?

=DLookUp("VATAmountGBP","tblSalesSummary","TaxCode='AR'")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[micruys]

Thanks for the replies, but so far no luck with the suggested coding...

 

[micruys]

Coding works fine now, I had to replace the , by a ;

Many thanks for your help!!!