New Record on different table than form is

[mac7attack]

I need to create a new record in TableB based on the information entered into TableA's form. How would I create the new record through VBA when a button is clicked?

Thanks Matt

 

[PHV]

Which application ?
If access, take a look at Recordset in your help file.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884