Problem with Dlookup
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
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!!