Exporting selected data to another database

[MelissaBerrett]

I have a table that has a checkbox for every record. Once the check box has been checked, I would like to export the record to another database, or even another table if that is easier. How do I do this? Thanks!!!

 

[mp9]

You need to start of by creating a form based on your table. Then, for the check-box you want to trigger the event you need to write some code on the AfterUpdate event, something like:

Private Sub chkMyField_AfterUpdate()
Me.Dirty = False
DoCmd.TransferDatabase acExport, , , , "tblMyTable", "c:\temp\db1.mdb"
End Sub

This example is pretty simple - it exports the

tblMyTable

table to

c:\temp\db1.mdb

. The

Me.Dirty

line equates to saving the current record you've just modified by ticking the check-box.

Hope this helps.