I'm trying to use the DLookup function in the Control source of a text box. I am trying to look up a product name using the product code. as soon as i click off of the text box (to save or whatever) its going away...
=DLookup("[Flavor]", "tblFlavors", "[ProductCode] =" _
&...