SteveL13

<div>
I assume you mean the beforeupdate event of the form, correct?
</div>


<div>
<div class="content wysiwyg-content">
I have 3 text fields on a form. &nbsp;They are txtCode, txtLastName, and txtCombined. &nbsp;txtCombined puts the 1st two fields together. &nbsp;So, for example, if I enter &quot;1234&quot; (is a text field), &nbsp;in the first field and &quot;Johnson&quot; in the 2nd field then txtCombined displays 1234Johnson.<br />
<br />
But if I have already entered that combination in a previous record I want to display a message to the user letting them know that combination already exists and undo the two field entries so the user can try again.<br />
<br />
I've tried all kinds of beforeupdate and afterupdate events and oncurrent events but nothing is working. &nbsp;Thoughts?
</div>
</div>


I have 3 text fields on a form.  They are txtCode, txtLastName, and txtCombined.  txtCombined puts the 1st two fields together.  So, for example, if I enter "1234" (is a text field),  in the first field and "Johnson" in the 2nd field then txtCombined displays 1234Johnson.

But if I have already entered that combination in a previous record I want to display a message to the user letting them know that combination already exists and undo the two field entries so the user can try again.

I've tried all kinds of beforeupdate and afterupdate events and oncurrent events but nothing is working.  Thoughts?

Not allow data entry in a new record if situation already exists.

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.