Populate from one form to another

[IwannaBNVegas]

Hi,
I'm very new at access. I want to make a database for a moving company, here's where I'm stuck:



Our customers move from
1234 XXX Street
Los Angeles, CA, USA

to

5678 YYYY Street
Paris, France

a few months later, they move to:

91011 ZZZ Street
Orlando, FL, USA

Every time they move, we will update their "Customer Profile" to the address where they currently live.
Every time they move, the current address will also be "origin address".

Now the question:
is it possible (with a button, maybe) to fill the "origin address" automatically (from customer profile), but when the address in the "customer profile" changes, the "origin address" won't change for this move. I hope this makes sense.

If not, please let me know.

Thank you for your help.
Sylvia

[June7]

Options:

1. Save the actual full address in each move record.

2. Have a table of addresses. Each address has a unique ID. Save the unique ID in the customer profile record and in the move record.

[IwannaBNVegas]

I just want to avoid typing the address twice. Once for the customer profile and again for the move.
Kind of like when you have customers and orders. A customer may order many times, and usually use his address as the send to address, but sometimes they may want to ship it somewhere else.
I hope I'm making sense.

[June7]

If origin and profile addresses can be different then need independent fields to save data. If you don't want the origin address for previous move records to change when the profile is changed to a more current address, then must do one of the options I indicated.

[IwannaBNVegas]

Maybe I'm thinking too complicated. Is there a way to make a button to Copy from From1 and Paste on Form2? And when I make changes on Form1 it won't influence Form2? Thanks for your help!

[June7]

Yes code can copy the data. What fields is form 1 bound to? What fields is form 2 bound to? My previous comments still apply.

[IwannaBNVegas]

They are both bound to Tables. tblShippers and tblOriginAddress.

[June7]

Still don't have anything new to offer. Which of the suggested options do you want to use?

[IwannaBNVegas]

It doesn't matter. I guess the one which is easier to explain, since I'm so new at this.

[June7]

You need to be aware that 'copy/paste from Form1 to Form2' is meaningless if data on Form2 has no place to be saved.

I guess option two is easiest.

Build a table of addresses. This table can have a field to identify customer the addresses are associated with.

Fields in customer profile and table of move records for the address ID as foreign key.

Comboboxes on forms to select address. Choices can be limited by the customer ID.

Just don't know enough about your data structure and form designs to be more specific.

[IwannaBNVegas]

I will try that. Thanks for your help. )