I am trying to grab a record id using Dlookup the issue i am running into is that I am trying to get the ID by matching a string
ex:
RecID=Dlookup("RecID","Table","String=" & sting)

This works fine until the string has an "'" in it, I know why this is an issue I just can't seem to figure out a way to get around it.
Any help would be great!!

Jim

Assuming Access 2000 or later:

Try:

RecID=Dlookup("RecID","Table","String='" & Replace(string, "'", "''" & "'")


Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com