Hi there,
Can a Dlookup command search for part of a field rather than the whole thing. EX.
Dlookup is RecipientX = DLookup("RecipientID", "MasterFeedData", "[Logins]=" & Me!JID)
Logins field contains CITIGRTS,CITIGRPS,GTORTTRO
jID input contains CITIGRPS
Currently dlookup looks for an exact match between Logins and JID. I want to change the Dlookup to look for partial matches in the Logins field if possible.
Thank for any assistance.