Copying data in a form to another part of the form

[Guest]

I have a table called EVENTS that i use with a form to process information
for an events management company. Customers usually only hold events once a
year or so and their information changes so often we have no use for a
CUSTOMERS table because we enter new info on a per-Event basis.

Most of the time the Billing information is the same as Shipping
information. What i would like to do is create a clickable button that
transfers all the Billing fields in my Events form (Bill_Street, Bill_City,
Bill_State, Bill_Zip) into corresponding Shipping fields (Ship_Street,
Ship_City, Ship_State, Ship_Zip).

Again, there is only one table the Events form uses and that is EVENTS.

 

[Nikos Yannacopoulos]

Not sure I agree with your design, but anyway... the code behind the button
would be:

Me.Ship_Street = Me.Bill_Street
Me.Ship_City = Me.Bill_City
Me.Ship_State = Me.Bill_State
Me.Ship_Zip= Me.Bill_Zip

HTH,
Nikos

 

[Guest]

Thanks so much, worked like a charm

HM

Not sure I agree with your design, but anyway... the code behind the button
would be:

Me.Ship_Street = Me.Bill_Street
Me.Ship_City = Me.Bill_City
Me.Ship_State = Me.Bill_State
Me.Ship_Zip= Me.Bill_Zip

HTH,
Nikos