Exit a half populated Form without saving record

[Steve78]

Hi could someone point me in the right direction for this one,

I have a series of linked tabbed Forms. One of the Forms is mostly populated by Combo boxes which all work fine. My problem occurs when you go to add a new record and populate the form with the combo boxes but decide for some reason not to save the record but exit the form using the Close form command button or by using the close button at the top of the Form. Access seems to Save the record anyway. I have placed an Undo Cmd on the form to clear all text boxes which works fine but it does not stop a user from closing or exiting a Form by another means and stop them saving that incomplete record.

I would be grateful for any thoughts on how to solve this problem.

Thanks in advance

 

[RuralGuy]

Try this thread: ghudson's Better MouseTrap

 

[bonekrusher]

you can also add the undo command on certian conditions. on exit add #DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70#

for example:

if isnull(me.textbox) then DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70


good luck

 

[ghudson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

A Better Mouse Trap?

Enable/Disable The Control Box X Button

The forms Before Update event is the key to data validation at the form level.

 

[Steve78]

Thanks guys just what I needed glad to know your out there!