Can't make a Dlookup work - please help !

[mermaidboy]

I have a form called InventoryDetailForm with a control called SupplierID. The record source for the Form is a query called PriceListQuery. I also have another table called SupplierAccountTable, in which there is a field called Discount%, as well as a related SupplierID field. I want to display this field on the form - hence:

=DLookUp("[Discount%]","SupplierAccountTable","[SupplierID]=" & [SupplierAccountTable]![SupplierID])

I don't want to add the SupplierAccountTable to the main PriceListQuery as then I cannot edit the records, which is why I am messing around with dlookup.

Any help welcome...



Thanks,

N

[June7]

The parameter must reference a field in the form RecordSource. Makes no sense to reference the SupplierAccountTable field.

=DLookUp("[Discount%]","SupplierAccountTable","[SupplierID]=" & [fieldname])

Advise not to use punctuation/special characters (underscore only exception) in names. Better would be DiscountPct.

[pbaldy]

If you use a combo for supplier this would be more efficient:

http://www.baldyweb.com/Autofill.htm

[mermaidboy]

Thanks - got it.