S SteveI Registered User. Local time Today, 17:13 Joined Apr 22, 2012 Messages 20 Aug 23, 2014 #1 Please assist...Is it possible for a DLookup code to work when the lookup filed is a text field. It works when it is a number field. Attachments Database4.accdb Database4.accdb 896 KB · Views: 169
Please assist...Is it possible for a DLookup code to work when the lookup filed is a text field. It works when it is a number field.
G Galaxiom Super Moderator Staff member Local time Tomorrow, 03:13 Joined Jan 20, 2009 Messages 12,876 Aug 23, 2014 #2 Yes, but the criteria need to have single quote delimiters. Code: DLookup("whatever", "tablename", "fieldname='somestring'") or Code: DLookup("whatever", "tablename", "fieldname='" & somevariable & "'")
Yes, but the criteria need to have single quote delimiters. Code: DLookup("whatever", "tablename", "fieldname='somestring'") or Code: DLookup("whatever", "tablename", "fieldname='" & somevariable & "'")
S SteveI Registered User. Local time Today, 17:13 Joined Apr 22, 2012 Messages 20 Aug 23, 2014 #3 thank you. It worked!!
