I have a customer database that has shipping and billing information on one form. Most of the shipping information is the same as the billing information. I would like to be able to click a button to copy the information from shipping and add it to billing to make it the exact same address. I know this is possible, but don't know how to do it. Thanks in advance for the help.
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Transfer Fields
- Thread starter dyow
- Start date
There are several ways.
Use the after update event of shipping to copy the data to billing:
[tt]Me.[subform control name].Form.[Textbox name]=Me.[Textbox name][/tt]
You could use the recordset clone of the form:
[tt]rsBill=Me.[subform control name].Form.RecordsetClone
rsBill.AddNew
rsBill.FieldName=Me.[Textbox name]
rsBill.Update[/tt]
You could use an append query, best built with the query designer.
Use the after update event of shipping to copy the data to billing:
[tt]Me.[subform control name].Form.[Textbox name]=Me.[Textbox name][/tt]
You could use the recordset clone of the form:
[tt]rsBill=Me.[subform control name].Form.RecordsetClone
rsBill.AddNew
rsBill.FieldName=Me.[Textbox name]
rsBill.Update[/tt]
You could use an append query, best built with the query designer.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
