Re populate a form

[Parker]

I have an order form that is poulated from a mixture of queries and user input.

This form is used to collate the information necessary to colect a client from (a) and deliver them to (b) on a given day

If they then want to return from (b) to (a) on a different day then a new job has to be generated, But, this second job is nearly always booked at the same time.

So, in order to save time and save having to input a lot of the data twice I want to include the option on the form for the opperator to book this second job.

90% of the information needed for the second half of a job like this is the reverse of the information already taken for the first half (i.e. Destination Address becomes Collection Address etc,)

How can I use a command button to open a new booking form against the same client and reverse addresses and other information, retain client information, generate a new job number, etc. and still leave options for entering other additional infomation.

Any ideas

Thanks

 

[dcx693]

Your command button needs to do a few things:
(1) save the current record, if needed, so you can base the new record on it
(2) open the new booking form you want
(3) take the appropriate values from the existing record and place them into the new record. Since most of this will be the same as what's on the existing record, you just need to properly reference the existing values

 

[Parker]

Thanks

(1) save the current record, if needed, so you can base the new record on it (2) open the new booking form you want

First two stages no problem I can do that.

But how do I repopulate the new instance of the form with the relevant info from the prev. order, get it in the right places and then save as a new job?

I tried to do this and messed it up -- big time

 

[dcx693]

Just to be sure: are you using the same form to do the input for the new record? Or popping open a different one?

 

[Parker]

At this moment in time I'm doing niether as my attemps to sort this where so poor that I undid all my mods to start again. So I could do either