Add Record in a Second File following Add in First File

C

ckrogers

Is there a command I can use to copy certain fields from a record in one file
to add a record to a second file. I've used the "Open Form" [Add Mode] with
"Set Value" before ... but I don't want to open any forms.... I just want to
add the record to the second file with certain field values automatically
filled in based on values from the first file. I plan on executing the code
on the "After Insert" event.

Can anyone help, please? Thanks!

Cindy
 
Top