Add record based on other record

[Back2Basics]

Hi

is it possible to create a new record based on the information on an existing record?

I would hope to do this from a form view - as an example, I would be hoping to create a new invoice based on a previous invoice. So if you search a previous invoice, then I would hope for a button that would then create a new record with some of the fields completed using the current record details - such as customer name, customer address etc. Nothing too specific, but a few things that would mean you didn't have to input everything all over again.

Possible example below:

Existing Record

Customer ID	Customer Name	Customer Address	Customer Phone number	Items	Cost
105	J. Edwards	32 Wallaby Way	01234 567810	Product 1	£350.00

New Record

Customer ID	Customer Name	Customer Address	Customer Phone number	Items	Cost
105	J. Edwards	32 Wallaby Way	01234 567810

[June7]

Yes, this can be done with VBA code. However, should not be duplicating the customer info into every order record.

[Back2Basics]

Hi June

Thanks for the message. Do you have a link which would help me find the VBA code I need?
And what could I do instead of duplicating customer info?

[June7]

Only the Customer ID should be saved into invoice records. Select customer from a combobox dropdown list.