Novice
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
Novice
I think no-one has replied because your question needs some clarification.
Can you post code fragments showing the recordset source?
What do you mean about the table changing after each event?
Posting Permissions
Reply With Quote