Question Locked

Automate the copying of data from a master form to a subform

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to setup Customer Entry process using an MS Access Form. There will be 2 parts to this process. First, A Form labeled 'Billing_Detail', which has fields for Billing_ID, Billing_Name, Billing_Addr1, Billing_Addr2, Billing_City, Billing_State, and so forth. WIthin this form is a subform for Shipping_Detail. Most of our customers usually have the same billing and shipping addrsses but in their are cirumstances that require we have multiple shipping locations for a single billing address. Since we need to forms for this, I wanted to make the data entry easier on our staff so the solution I came up with is to include a check box on the shipping form that says "Shipping info is the same as billing info." However, I can't figure out how to automate the data to copy over from the billing detail. The fields are mostly the same. I think I am going to have to use some visual basic here but I'm not sure. Any help will be greatly appreciated. Thanks.

2 replies

by maevinn

Have a separate table for Shipping Address. In the Billing Address table, have a checkbox for 'shipping info is the same as billing info'. If this isn't checked, allow entry into the Shipping Table. When it comes time to populate the labels, use and if then to ID those where an alternate shipping addy is used and pull from the table as appropriate--otherwise, the data is collected and stored just once (which is the way it should be--you don't want to duplicate records that are identical).

This discussion is closed to new replies.