how to copy 1 item from one table to another table?

[Giantb]

Hello and HELP !

I have 2 tables (main) and (daughter).
there is a form which makes updates to records in the main table, and there is one combo box "status" which is constantly changing until the user is finished with the record.
I am trying to capture all this activity from this combo box and save it into a linked table for history. Every time someone clicks on the "status" combo box I would like that info to get copied into "ndstatus" column in "ndstamp" table and a second column to populate the current date.

I was thinking when the update form is open, can use an "on click" event procedure and have some code there. whenever anyone clicks in the combo box, that info will automatically get copied to the other table with a date stamp.

I am kind of (very) new to access and am wondering the best way to accomplish this.
the DoCmd.copyobject looks to only copy whole records or tables
the recordset is too alien for me to get going.

Any help is greatly appreciated
thanks

 

[KenHigg]

I would consider running an append query form the on change event of the combo box. See if this helps:

 

[Giantb]

Ken, that did it. thanks a bunch for yourhelp on this one!!

 

[KenHigg]

Glad to help.