I am trying to autofill a form based on a drop down menu. I want the price
and description of an item to autofill. I have looked through all the
posting, tried them, and still cannot get the darn think to work. Here is
what I have:
=DLookUp("[ContainerSize]","Chemicals","[ProductName] = ' " &
[ProductName]
& "'")
I am trying to look up the Price, in the Chemicals table, based on the
ProductName selected in the current form.
Any help would be appreciated.
