Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make a command button make one field = another field

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
While using a form, I need to make a button that would copy the billing information to the shipping information.

For example when typing a customers name and address on a form, if a customer is using the same billing and shipping information instead of typing it in twice, just click a command button to copy the billing information to the shipping information.

How would you do this?

Thanks
 
In the buttons CLICK event create a procedure like

Private Sub cmdDup_Click()

Me.txtShipToAddress1 = Me.txtBillToAddress1
Me.txtShipToAddress2 = Me.txtBillToAddress2
Me.txtShipToCity = Me.txtBillToCity
Me.txtShipToState = Me.txtBillToState
.
.
.

End Sub


where txtShipToXxxxx and txtBillToXxxxx are the respective forms field names.

Dave
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top