I know (I actually don't ) it is somthing stupid. I had this DLookup working but for some reason now it isn't. When it was working I had me.txtSerial, but with tiral an derror and other fourm suggestions it has changed to below.
It is embarassing how long I have spent trying to resolve this, but would appreciate any input.
I have a form(frmValidation) that is taking in a delimited string into a field. I am splitting the elements of the string into individaul text boxes, one being txtSerial, and my aim os to see if this value is in the tblPassed table.
Thanks in advance.
Code:
If DLookup("[Serial Number]", "[tblPassed]", "[Serial Number] ='" & [Forms]![frmValidation]![txtSerial] & "'") Then
MsgBox "Serial Number is Good"
It is embarassing how long I have spent trying to resolve this, but would appreciate any input.
I have a form(frmValidation) that is taking in a delimited string into a field. I am splitting the elements of the string into individaul text boxes, one being txtSerial, and my aim os to see if this value is in the tblPassed table.
Thanks in advance.