I have a a form like below with data source tblPatients.
I want to be warned of duplication when I add a new Surname & FirstNames
When I enter a FirstNames
, before update, I want the form to test whether an equal Surname & FirstNames
already exists in tblPatients.
Will you please help me with the VBA.