Need some help to copy data from one table to another table in acces database

Hello,

I'm using a database from a Point of Sale program. I'm missing some simple tools in this program so i want to make a program whitch will fulfill my needs.

I'm having a problem how to copy certain data from a table to another table. The database is a access database. This is what i want to do:

- I have a button to push to copy the data from a record in a grid to another table

- there are only 4 fields i need to copy to the other table

- i'm using studio 2005 express

Can someone give me a hint or some code

Thanx

Michel

Hello,

Thanx for the quck replay,

I need to copy the data of the fields:

Item Number

Item Name

Price

Type

to the same names in another table

The Point of sale database is not very proffessional made, because they used spaces in the field names.

Greetings Michel

I just moved the grids from the datasource to the form. Let me show you with a picture how it looks. It's just simple as it looks.

http://www.gameshopplayit.nl/Studio2005.jpg

I need to copy the mentioned fields from the upper grid to the lower grid with the button on the top. It must copy the selected row to the grid below. What i want is to copy a few rows to the below grid. The pos program makes some labels for me to print out with the below table.

Thanx for your time

Greetings Michel

I think not, because the second grid is not nececery, the data must be copied into that other table and not into the second grid. I can even delete the grid i you want me to. Just need to copy the data i select in the upper grid to that other table. Can you point me out how to do that

Thanx

Michel