database question

[Leeper77]

ok i need to know how to copy one record from one database to another in vb I have one form that has one database and another database that has another using a data control. the one database has a add to database which is on the form that has the original database. What i want to do is this
1. when add is clicked then it shows the other form with the data in it and copy it to the new database
2. since the add is on the other form i would like to know how i can access the db on the other form to make the add and update and to show the names etc on the other form

any suggestions?

Thanks

[JeffSM]

This can't solve?

'Supose this code are in Form2
Form1.Data1.Recordset.AddNew
'Other commands
Form1.Data1.Recordset.Update

Good luck!
Jefferon

[Leeper77]

ok i tried that it doesnt seem to work i know what it is but how can i copy the fields over can i copy them over individually?

[Randman]

you can do this
try ms kb article # Q108147