I have a dlookup expression as follows:
Me.PO_Number = DLookup("[Customer PO]", "Order Header", "[SO #] = " & Me.[Sales Order Number])
Order Header is a query. Sales order is a number and matches appropriately to the table data type. When entering a number that I know has a match in the query, I get:
Runtime Error: The number you entered isn't valid for this field. It will allow any number to be entered except those that have a match in the query. Testing out the lookup in its own query I get the correct answer, but the value repeats for all lines in the query. However, the sales order number only appears in one row in the query.
Any ideas as to why this is happening? Thanks!