Transferring Text Box Contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top