Table to table

[cvboas]

Hi, again...
I have a problem. I want to create a button to send the data of a table to another table. I have a table "budget" and i want so send to another one "order".
Thanks

 

[Lister]

Write a append or update query (depending on what data you are going to be moving) this will move the data if it fits the criteria that you set.
To run the query (or SQL) from a form create a button to run the query. The wizard should walk you through that bit.

Thats about it.
Good luck