<div>
But of course there is no reason a all why the database can NOT have two patients with the same name. &nbsp;There could easily be ten John Smiths in a patient records system.
</div>


But of course there is no reason a all why the database can NOT have two patients with the same name.  There could easily be ten John Smiths in a patient records system.

<div>
<div class="content wysiwyg-content">
I have a a form like below with data source tblPatients.<br />
<br />
I want to be warned of duplication when I add a new <b>Surname &amp;&nbsp;FirstNames</b> combination.<br />
<br />
When I enter a <b>FirstNames</b>, before update, I want the form to test whether an equal <b>Surname &amp;&nbsp;FirstNames</b> already exists in tblPatients.<br />
<br />
Will you please help me with the VBA.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/08_w35/932264/Patients.png" target="_blank" title="Patients.png (16 KB)"><img alt="Patients.png" class="file-block lazyload" style="max-width: 453px;" data-src="https://filedb.experts-exchange.com/incoming/2015/08_w35/932264/Patients.png" /></a>
</div>
</div>


Patients.png

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 combination.

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.



Prevent duplicate Name&amp;Surname combination in form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Prevent duplicate Name&amp;Surname combination in form

Prevent duplicate Name&Surname combination in form