Repeat Order Macro/Button

[DMWM]

Hi I've been searching through for a solution to this duplication but i
cannot seem to find one.

The basis is that customers will order products then after a month/year/any
timescale may want the same order again. The company are happy to give the
same price aswell, as each order is individually quoted.

Each previous job appears on the customer form as a record. I need the
details, which are also stored in the job form, to be put as a new job
(obviously on the job form)

Is it best to copy from the customer form to the job form OR copy from the
job form to the job form?

Also, where do i start with coding this button?

Many Thanks in advance for the superb advice i get from this discussion group

 

[John W. Vinson]

Each previous job appears on the customer form as a record. I need the
details, which are also stored in the job form, to be put as a new job
(obviously on the job form)

Is it best to copy from the customer form to the job form OR copy from the
job form to the job form?

Neither, since the data doesn't exist in either form!

Instead you would run an Append query to copy the appropriate record or
records from the jobs table into a new record in the jobs table. The details
will depend on how your tables are structured and related... which I don't
know.