DLookup function

[samotek via AccessMonster.com]

In my form I need to build a Dlookup function and I need a help.My task is
the following. In my table products I have the fields code,suppliercode and
grossprice.
In my form I have a blank field called Supplier Grossprice.I want to enter a
dlookup function in this field finding the grossprice against this code.
For example in the first row I have code = 16733 and grossprice 20.96
The second row contains a filled in field SupplierCode = 16733
With the Dlookup function I want the next field, called SupplierGrossprice to
show 20.96
How can I do it?

 

[Tokyo Alex]

Hi,

I believe
=Dlookup("[grossprice]","[products]","[suppliercode] = " & Me.SupplierCode)
should do it.

If suppliercode is a text field, you'll need to add quotes:
=Dlookup("[grossprice]","[products]","[suppliercode] = """ & Me.SupplierCode
& """")

Cheers and hope this helps,
Alex.

 

[samotek via AccessMonster.com]

Thank you very much ! It is excellent !

Hi,

I believe
=Dlookup("[grossprice]","[products]","[suppliercode] = " & Me.SupplierCode)
should do it.

If suppliercode is a text field, you'll need to add quotes:
=Dlookup("[grossprice]","[products]","[suppliercode] = """ & Me.SupplierCode
& """")

Cheers and hope this helps,
Alex.

In my form I need to build a Dlookup function and I need a help.My task is
the following. In my table products I have the fields code,suppliercode and

[quoted text clipped - 6 lines]

show 20.96
How can I do it?