<div>
I would recommend using DAO.<br />
<br />
and the execute method of a database object<br />
<br />
Is there a reason why you are not?<br />

</div>


I would recommend using DAO.

and the execute method of a database object

Is there a reason why you are not?


<div>
<div class="content wysiwyg-content">
I'm trying to use the DoCmd.RunSQL to insert a run in a table, using two of the fields on a form. &nbsp;The table I'm trying to insert in is not associated with the form? &nbsp;How do I refer to the fields on the form. &nbsp;One of the fields is from a combo box and is hidden (i.e. primekey)
</div>
</div>


I'm trying to use the DoCmd.RunSQL to insert a run in a table, using two of the fields on a form.  The table I'm trying to insert in is not associated with the form?  How do I refer to the fields on the form.  One of the fields is from a combo box and is hidden (i.e. primekey)

Updating a table in MSAcess using fields from forms

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.