ACCESS 2007 save record question.

[dmon2010]

I have a form that I use to enter orders into a database (Access 2007). The form has the standard save record, new record, find record buttons that I use. Sometimes I'll get a single order that consists of 2 line items (for example, on order number '12345' the customer may want 50 pieces total but 25 to ship to CA and 25 to ship to TX). That order should get stored in the database as '12345' and '12345A'. Currently, I have to enter the data (such as Customer, Billing Address, etc) twice in my database, only changing the "ship to" field and adding the letter "A" to the end of the order number.



Is there a way to enter the order once, then view the order and change the "ship to" address, add an "A" to the end of the order number and save it as a new record?

I've tried entering the first part of the order and saving it, then going back in and making necessary changes but it only changes the original entry. For example, instead of ending up with 2 entries (12345 and 12345A) only the first entry gets modified and I end up with a single entry. I think I need something like a "Save As" button or something similar, but I'm obviously not that familiar with Access yet.

Hope I explained properly and any help would be greatly appreciated.

[burrina]

You can have a ShipTo address for each line item if that is what your asking. You should NOT have to enter the info twice. I see no need to store as 12345 and 12345A myself.
Access automatically saves your record by the way when you close or go to another record.

[dmon2010]

Thanks for your reply. Unfortunately, the way things are set up within the company, I have to store them separately (as different entries) due to purchasing and PO issues. As far as adding a ship to for each line item, I don't think that would work because sometimes I have only 1 line item, but sometimes there are multiple line items. Occasionally there will be up to 50 line items depending on the order. Basically looking for a way that I can view an existing entry, add a letter to the end of the order number (and change the ship to and/or qty when needed), and save it as a new record.

[burrina]

You could try something like this.

Me.Somefield = [SomeValue] & "-" & [PrimaryKey] & "A"

HTH