<div>
I attempted to edit the question but too late. &nbsp;I wanted to also ask for the code that will actually add the record. &nbsp;There are 3 textboxes for data entry and a command button. MyTable has 3 fields. &nbsp;Can I get the code to actually write the data from the textboxes to the table?
</div>

<div>
the form should be bound to the table -- turn on the Property Sheet by right-clicking in Design View and choosing &quot;Properties&quot; from the shortcut menu 
 
click in the upper left, where the rulers intersect, to select the form 
 
on the DATA tab of the Property sheet, choose your table in the Record source property 
 
for each of the controls, on the DATA tab, set the Control Source to the field 
 
here is code I put in a general module to call to add a record: 
<pre><code class="code-10 nolinks" id="code-20-41838605-1">'~~~~~~~~~~~~~~~~~~~~~~~~~~ RecordNew
Function RecordNew(Optional pF As Form _
 , Optional pFirstControlName As String = &quot;&quot;) As Byte
' Crystal (strive4peace)
'3-20-09... 160819
 
 'example useage: Click [Event Procedure] for a New Record command button
 ' Call RecordNew(Me)
 ' RecordNew Me, &quot;Controlname&quot;
 'can also be assigned on the property sheet
 'to make logic copy when buttons are copied
 ' =RecordNew([Form])
 
 'NOTE: specify form parameter for subforms
 
 On Error Resume Next
 'if form reference was not passed, use the active form
 If pF Is Nothing Then Set pF = Screen.ActiveForm
 
 'with the referenced (or active) form ...
 With pF
 'if there have been changes to the current record, save them
 If .Dirty Then .Dirty = False
 DoEvents 'do it now
 On Error GoTo Proc_Err
 'create new record
 If Not .NewRecord Then
 If Not .AllowAdditions Then
 .AllowAdditions = True
 End If
 .Recordset.AddNew
 End If
 'set focus to first control, if specified
 On Error Resume Next
 If pFirstControlName &lt;&gt; &quot;&quot; Then
 .Controls(pFirstControlName).SetFocus
 End If
 End With
 
 DoEvents
 
Proc_Exit:
 On Error Resume Next
 Exit Function
Proc_Err:
 If Err.Number = 2046 Then
 ' already on a new record
 Exit Function
 End If
 MsgBox Err.Description, , _
 &quot;ERROR &quot; &amp; Err.Number &amp; &quot; RecordNew&quot;
 
 Resume Proc_Exit
 Resume
 
End Function
</code></pre>
</div>

<div>
When you use bound forms, Access handles the details. &nbsp;It ALWAYS saves dirty records 
1) when you move on to a new record 
2) when you move from a main form to a subform or vice versa 
3) when you close the form 
4) when you close the database 
5) there are probably other places. &nbsp; The point is that Access ALWAYS saves the data or if it can't, gives you an error message. 
 
What exactly are you worried about?
</div>

<div>
<div class="content wysiwyg-content">
I have an MS Access database that has a form with an &quot;Add Record&quot; command button. &nbsp; &nbsp;How can I confirm that a record has actually been added to the table when the button is clicked? &nbsp;Obviously I can look at the table itself but data entry personally, who will be the ones entering the records once the database is up and running will not. All they will have is the form to look at (with the textboxes for data entry and the command button for adding the records). &nbsp;I want to ensure when they're doing their data entry that the records are actually being added. &nbsp;Thank you.
</div>
</div>

I have an MS Access database that has a form with an "Add Record" command button.    How can I confirm that a record has actually been added to the table when the button is clicked?  Obviously I can look at the table itself but data entry personally, who will be the ones entering the records once the database is up and running will not. All they will have is the form to look at (with the textboxes for data entry and the command button for adding the records).  I want to ensure when they're doing their data entry that the records are actually being added.  Thank you.

Confirm a record has been added MS Access

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.