Copying fields from one table to another

[Jimbo]

Hi Guys, I'm hoping one of you will give me a leg up with a problem Im
having, which I think is possible to do. Let me explain.

I have 2 tables and 1 form - ie 'tableDigit', 'tableNumber' and
'formDigit'.

'tableDigit' has 2 fields - ie 'digit1' and 'digit2',
'formDigit' is used to input data to 'tableDigit'.
'tableNumber' has 1 field - ie 'Number'

Lets say that the first 2 records of tableDigit have the following
data.
Record 1 - Field 1 = A, Field 2 = B.
Record 2 - Field 1 = C, Field 2 = D,

I want to put a button on formDigit that will open do the following
1 - open 'tableNumber' (I can do that)
2 - go to a new record in tableNumber (I can do that)
3 - populate the (single field) records of tableNumber, as follows
1st record = 'A' followed by a space, then 'C'
2nd record = 'A' followed by a space, then 'D'
3rd record = 'C' followed by a space, then 'A'
4th record = 'C' followed by a space, then 'B'
4 - Save the table (I can do that)
5 - Close the table (I can do that)

Basically, the essence of my query is what code (if any) can I use to
loop through the records and fields of tableDigit, and auto-write the
values to the records of tableNumber.

Any help would be greatly appreciated, thnks, Jimbo

[Bas Cost Budde]

Jimbo wrote:

I want to put a button on formDigit that will open do the following
1 - open 'tableNumber' (I can do that)
2 - go to a new record in tableNumber (I can do that)
3 - populate the (single field) records of tableNumber, as follows
1st record = 'A' followed by a space, then 'C'
2nd record = 'A' followed by a space, then 'D'
3rd record = 'C' followed by a space, then 'A'
4th record = 'C' followed by a space, then 'B'
4 - Save the table (I can do that)
5 - Close the table (I can do that)

You are trying to do too much by hand. Usually, you put records in a
table by using an insert query.

Of course you can loop a recordset (opened table, or query) but I
suggest you try to formulate the records to be inserted as a query result.