Continuous form - Save all changes to all record at once (wait 'til the end)

[MBlondinde]

Hello.

I have a continuous form where the user select an entry using a combobox. Upon selection, detail records are displayed in the detail section. The user can change some values and also add new record. I would like to be able to wait before saving the data back to the database (SQL Server) by forcing the user clicking on a Save button so I can perform global validation. I do not want the save to take place as soon as the user select the next detail record. As an example, the sum of quantities should be equals to a standard value as per the initial combobox selection so I must validate all records together before I can save.
How can I achieve this?



Any help would be appreciated.
Thanks.

M.

[June7]

Can't with bound form. Normally. There is a process called "Transactions" that could be invoked. If a condition is not met then every thing done since the "Transaction" started would be automatically undone. Gets complicated.

[NTC]

A continuous form is line by line ; meaning that there is no such thing as 'wait til the end' in the human sense. Each line/row has it's end and that's it. You will need to trigger your check at the end of each line/row - if your goal is to undo it. After the cursor has moved on to the next row - the prior row is written and there is no memory of any prior data values in the prior row.

You could apply a flag, checkbox, to a newly added/edited row; and then when the form closes use this flag to identify these rows and then apply some logic against them to perhaps provide a message to the user (and then clear those flags) - - - but you could not undo or return to prior values per se...