Copying data between tables

[stu_c]

hi all,
Right I have two Tables lets call them Table-A & Table-B

I have a form for both tables is it possible to create a macro of some sort to copy all the information from the viewed record

So for instance if I am looking at TableA, record one is it possible to click a button and transphere the details into tableB and delete the record from TableA

 

[vbaInet]

You needing to do that sounds like an issue with your tables not properly normalized. What's the situation?

 

[FoFa]

Yes, but some pitfalls.
Click your button:
1 - Run a query that gets a PRIMARY KEY for THAT record from the form, or stored somewhere, to use as a criteria to get the proper record, and appends it to Table-B.
2 - Release the record from your form (so it is not locked).
3 - Optional, verify the copy worked properly, stop if it did not.
4 - Run delete query to remove the record from Table-A

Basically