Hi Board,
I have a form that recalls a product price from a table (tblFurniture), using a dlookup.
As follows:
UnitPrice: DLookUp("[1stBand]","tblFurniture","[ProductNameText]='" & [Element] & "'")
This works fine, but I want to return the price based on the selected band (1st,2nd,3rd etc)...