deleting saved data from a form

[goldstar1982]

Hello All,

I currently have an order form, when an item is selected and then an add button is pressed this saves the data orderline within the table, for example half way through the order a customer wanted to cancel the whole order placed, i want to delete everything that had been saved so far for this customer on this current order. Any ideas?

eg. an item is selected then add is pressed, this will save within a tblorder and be displayed on the order form, if for what ever reason clear form or exit is selected i want the form to refresh and the order saved so far to delete. hope this is clear.


Thanks

 

[ajetrumpet]

if for what ever reason clear form or exit is selected i want the form to refresh and the order saved so far to delete.

You save everything to the table initially? Have you seen the following thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=137158

Here I use a query to display the "temporarly saved" information, and display it on the form. Essentially, the "saved" data is stored in a separate object, rather than the table. This makes it a lot easier to delete the data after someone is halfway through the task of entering it all in...