Closing a form without saving 1

[postmanphat]

Hi,

Is it possible to close a form without saving the information you've entered?

I have a database where users enter details when a new grant application is received. If somebody starts entering info then half way through, for whatever reason, they decide they want to discard that info. At the moment the 'close' button (created using the button wizard - close form) automatically saves the info before closing the form. I want another button to close the form and discard the data.

Many thanks in advance,

Dave

 

[Remou]

If you do not have any subforms and if the data has not been saved in any other way, Undo may suit. However, I have found that it is generally easier in the end to use an unbound form to collect the essential information for new records.

 

[postmanphat]

The form has a tab control on it and subforms on each page of the tab control. Good idea about using an unbound form to initially capture the data, I'll remember that for future use! - but I've obviously put a hell of a lot of work into my bound forms so I'll keep that as a last resort for now.

I suppose I could just have a delete buttoin that would delete the current record being worked on... its just a data entry form so there would be no danger of people accidentally deleting completed forms....

 

[postmanphat]

I've used delete record and it works a treat.

Thanks anyway.

Can I give myself a star?

 

[Remou]

If you are using delete, make sure you compact and repair regularly.

 

[PHV]

You may try this in the Close event procedure of the form:
If Me.Dirty Then Me.Undo

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886