I have a question about copying record please

[foody]

I have two tables, one is called Table A and the other is called Table B:

Table A contains these data:
I
II
III

Table B contains no data

in the form of Microsoft Access, I want to be able with a push of a button and DEPENDING on the selected item, I want that selected item to be copied into table B. For example, in table A I am selecting item II, when I push the button copy, I want that item to be copied into table B.

So the result will be:

Table A Table B
I II
II
III

How does one solve this problem please?

 

[Pat Hartman]

You can use an append query, DAO, or ADO.

 

[foody]

Please be more specific than that, as far as that reply goes it is all jebrish to me. If you can give me some examples too that would be greatly appreciate it.

 

[Pat Hartman]

Start by opening the query builder and build an append query.

Choose the source table from the list presented.
Choose the columns you want.
Change the query type to Append.
Test it - it will copy ALL records from one table to the other. When you get that working post back and we'll work on how to enter selection criteria so you can choose specific records to copy.