DLokup function

[samotek]

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?

 

[dhookom]

What do you mean by "second row"? Form's display records. Forms have fields in the Record Source but have controls on the forms. I assume you want to enter a =DLookup() expression in a control source to find the GrossPrice from a table based on the value of a field in the form's record source.

Is 16733 stored in the primary key field of some table?

I see you have mentioned code, suppliercode, grossprice, and [Supplier GrossPrice]. Where are all of these stored? Are you referencing one table or multiple?

Duane
Hook'D on Access
MS Access MVP