Unwanted additional recordset after closing a form

[bokib]

Hi!
Solution is maybe simple, but I don't know it!
When I put some value in a control (textbox) on a form, and after that if I close a form (by x button) that recordset is added to a table, but I don't want to do that- I just want to exit (close) the form! How to avoid adding that recordset to a table?
Same things happens when I, by VBA, set focus to control, assign some value to it, and just want to exit the form.

Best regards,

 

[lightray]

one solution is to set one of your fields as a required field. As long as it is empty on close of form, the record won't save. Mind you have to deal with a couple of annoying exit messages "can't save the record...." but it's a solution. I'd be interested in any other ideas. Lightray

 

[neileg]

This thread may help you
http://www.access-programmers.co.uk/forums/showthread.php?t=102906&highlight=exit+saving

 

[gemma-the-husky]

if its a partial started new record you could just do

if me.newrecord then me.undo

in the close form event. this will get rid of any half edited item.

 

[Rich]

If you don't want records added to the db then use an Unbound textbox