i need help with commande

[radoinrara]

hello all, i m new with acces
i have a litle problem.
i want to create a form with a button that will update data from Table1(ProductCat) to Table2(ProductCat)
can you help me because i need it so mutch
thank you

 

[Ranman256]

Make a query to append data from 1 table to the other.
Put the button on a form
In the CLICK event of the button,
Choose macro,
Set a line in the macro to OPENQUERY,
Assign the query you made above.

 

[radoinrara]

thanks bro for replay
but i dont know how to do this.
can you give me a code or make a small fille with this things if you can.
and im so sorry for disturb you.