Transferring Text Box Contents

[Guest]

Help please

I am working in Access 2002 and trying to copy the contents of text boxes
from one set of fields to another. The table is OrderHeader01 and the fields
I am trying to copy across are from ShipToAddress (1 -5) to BillToAddress (1
- 5)
and the action of transferring I want to link to a command button.
I can't understand how to implement the record set coding

Thank you in advance for any assistance

 

[Guest]

Assuming that all the fields are in the form, and they all in the same table
On the On click event of the button you can write the code

Me.BillToAddress1 = Me.ShipToAddress1
Me.BillToAddress2 = Me.ShipToAddress2

Or
Dim I as Integer
For I =1 to 5
Me("BillToAddress" & I) = Me("ShipToAddress" & I)
Next I
The same with the rest of the fields