Here is my problem...trying to run a query to bring back a single record from a table using data from a form as the criteria. I then want to put the returned value as value of a text box in the form. Here is what I have to start
DoCmd.RunSQL ("SELECT UPC AS UPC FROM tbl_Reference_Table WHERE strLongDesc = " & List95)
Text4 = UPC
I get the following error...3075 Syntax error (missing operator) in query expression 'strLongDesc = (value of List95 is shown, no parentheses)'
Any help is appreciated