Auto populate an invoice record with same values as customers previous order

[Marvo]

Hi All

- as a time saving device, I wanted to auto populate an invoice record with same values as previously ordered by that same customer. I don't want to use default values as every customer orders different things.
BUT almost all customers make REPEAT orders of exactly the same things they ordered previously.

So...for example, can I search the invoice records by customer ID/Name and copy all the data from their previous into a new invoice record. I guess I could do this with an append query?
But will an append query run when I just click on 'new record' in the invoice form? Maybe there is a property '.on new record'...open append query....?

Am I on the right lines as can't seem to find a way to make it work
Thanks

[ItsMe]

If it were me I might use a pop-up form in ds view. It could be bound to a SELECT query. A double click event could run code to append a given record.