I am using this code:
and I just keep getting this error, "The Expression you entered as a query parameter produced this error: 'ILR2360'"
ILR2360 is the Lot# that I am trying to open. The table name is correct and so are the field names (I checked them like 5 times). What else should I be looking at?
Code:
SaveSetting "PST", "CopyProd", "ProdNum", DLookup("[PC]", "WAVE3_INVN_DL", _
"[LOT] = " & Forms!frmOpenLot!tbLotNum)
and I just keep getting this error, "The Expression you entered as a query parameter produced this error: 'ILR2360'"
ILR2360 is the Lot# that I am trying to open. The table name is correct and so are the field names (I checked them like 5 times). What else should I be looking at?