How to write data to a table

[Guest_imported]

I have vba snippet that gets the username, form name, time and date when a user opens a form. I would like to output this information to a table names UserInfo. How would I go about doing this? <p>John Vogel<br><a href=mailto:john@computerwiz.net>john@computerwiz.net</a><br><a href=

http://computerwiz.net>ComputerWiz</a><br>-================================-<br>

If you are interested in working on a very worthwhile Christian web project, please email me at<br>
volunteers@theocities.com<br>
-===================================================-<br>
-==============

 

[dreew]

Run an append query of that information to the destination table is the way i would do it, setting warnings off.

 

[phparadis]

If you want to use code.......<br>
Create a recordset for the table you want to update (ex rstUpdateRecords)<br>
rstUpdateRecords.AddNew<br>
rstUpdateRecords(&quot;UserName&quot = me!Username!.value<br>
remaining fields and values<br>
rstUpdateRecords.Update<br>
<br>
Both AddNew and Update are required