<div>
is your form unbound or is it bound to the table where you want to insert the record?
</div>


<div>
<div class="content wysiwyg-content">
I have a form with bound pull down text fields (from several different tables) that I want to push into one record into one table in the database. &nbsp;Most are text boxes and some are automatic calendar boxes. &nbsp;<br />
<br />
Example: &nbsp;Form1 with txtName, txtaddress, txtDate, txtCity (all drop downs come from separate tables)<br />
<br />
Want to push all of these fields into one record into tblTable that contains all of the same fields shown on Form1 with Add button on form. 
</div>
</div>


I have a form with bound pull down text fields (from several different tables) that I want to push into one record into one table in the database.  Most are text boxes and some are automatic calendar boxes.  

Example:  Form1 with txtName, txtaddress, txtDate, txtCity (all drop downs come from separate tables)

Want to push all of these fields into one record into tblTable that contains all of the same fields shown on Form1 with Add button on form. 

is your form unbound or is it bound to the table where you want to insert the record?

MS Access 2003 Form Pushing Data to Table

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.