Search results

I think it has something to do with PI Code in the FPSUM table as being a combo box. I designed it that way because I have five other fields on a form that autopopulate based on what is selected for PI Code. However, the information is not pulling into a query. If the PI Code is entered as...

They are both text fields. PI Code in FPSUM is a combo box which retrieves it's value from a query based off the Products2 table. PI Code1 on the Products2 table does not have a space between Code and 1 and is a text field and is a text box, not a combo box.

Thank you for the corrected dlookup; however, when I run the query I have no results at all now.

I have two tables - Products2 and FPSUM I am creating a query to look up the Product Code from the FPSUM table and return a Product value (text field) from the Products2 table. I have tried the following DLookUp and receive an error "Syntax error (missing operator) in query expression 'PI...

Hi, I'm relatively new to Access. I've created a database where we track product information and testing done on the products. I have the Product Code set up as a combo box with five other fields auto populating based on what is entered into the Product Code field. However, when I export the...