Alrighty, what I'd like to achieve is to have when a user enters a surname (field "Family Name") and first name (field "Given Name"), as an After Update event (I think?), Access checks the existing records in the table (which changes for each event*, but can just use me.recordset I think) for the same two values, and if there is one (or more) pops up a MsgBox.
I have NFI where to start, tried DLookup but got confused!
*not my design, I'm retrofitting an existing DB