Moving a recordset from one table to another

[morg27]

I have two databases. Both have a table for store info. The first database has the table with all the data and the other is empty. I have a form that when I enter the store ID in a text box the data in that accompanying row is moved to the new table in the second database. I have to do this for each store ID seperately. I need to use ADO for this task. Any advice would be appreciated.

 

[SBendBuckeye]

Little confused about what you are trying to accomplish here. If you always update the table with all the data, why do you need the emtpy table in the other database. Perhaps it would help if you could post some additional information about how your process works and what you are trying to do. A couple examples with the databases and tables labeled would also be helpful (eg table tbl1 in database dbs2, tbl3 in database dbs1, etc).

Good LucK! Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!