How to transfer automatically the record to other table?
i have table name tblDTS and tblARC
my form name is List the default view is Split Form
and another form name is Entry the default view is Single Form
i have two fields: subject and status
in my entry form i have one textbox for subject and one combobox for status, you have two option to select in this combobox (done and pending)
my datasource is tblDTS. when add record and i select done, i want this record to transfer automatically to the table tblARC.
any help will be highly appreciated..