<div>
&lt;enter event&gt;<br />
&lt;add to a text box's enter event to add a record after the uses hits enter,&gt;<br />
<br />
The event you are describing would actually be the textbox's after update event.<br />
<br />
I'd recommend using a command button's click event to insert a record instead.
</div>


<enter event>
<add to a text box's enter event to add a record after the uses hits enter,>

The event you are describing would actually be the textbox's after update event.

I'd recommend using a command button's click event to insert a record instead.

<div>
Hi sciarref,<br />
<br />
If your text box is bound to table or query field, just place Dirty = False into its After Update event.<br />
See snippet below for an example<br />
<br />
<br />

<pre><code id="code-591728">Private Sub Field1_AfterUpdate()
Dirty = False
End Sub
</code></pre>
</div>


Hi sciarref,

If your text box is bound to table or query field, just place Dirty = False into its After Update event.
See snippet below for an example




Private Sub Field1_AfterUpdate()
Dirty = False
End Sub


<div>
<div class="content wysiwyg-content">
I am new to Access and was trying to find the code to add to a text box's enter event to add a record after the uses hits enter, using the contents of the all the text boxes on the form for the record. &nbsp;Can somebody give me some beginner VB code for this?<br />
<br />
Thanks<br />
Frank
</div>
</div>


I am new to Access and was trying to find the code to add to a text box's enter event to add a record after the uses hits enter, using the contents of the all the text boxes on the form for the record.  Can somebody give me some beginner VB code for this?

Thanks
Frank

Adding record through a text boxes enter event

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.