I'm doing a simple DLookup in VB for an access database.
It worksfine unless the lookup value has quotes in it.
Some of the company's part numbers have single or double quotes for inches or feet respectively.
(not a good idea, but this company's database has been around a while)
I get a runtime error 3075 syntax error when the combobox value has quotes in it.
Me.txtLOC = DLookup("[LOC]", "[qryFRMInventory]", "[part_id]='" & Me.cmbPART_id & "'")
in this case the actual part_id is NYWIRSCREEN9.5"X1000'MESHEPOXY
How do i deal with random ' & " in my strings.