Hi,
I can't see it solved so I will give you an example here:
DLookUp("[In Stock]","Inventory","[Manufacturer Part Number]=" & "Part001")
This will lookup in database all records with 'Manufacturer Part Number' equal to 'Part001'. So best would be to either have a combobox with all possible...