Stop Saving new record when switching to design mode

[vfisher]

I'm using Access 97. I have a form that is opened as add and has some data preloaded from the previous form. Everytime I switch to design mode it tries to save the record. I have no idea what's causing this. I have a cancel on the before update because there's a save button. Any help will be greatly appreciated.

 

[rajeessh]

Is any save module called on Form Unload Event
Is the form u mean is a bound form?

 

[vfisher]

There is no code on the unload event. The Form is bound to an underlying query because I need to update data in one table while adding the new row in the other. I think this may be causing a problem but I'm not sure how to do this otherwise.

 

[rajeessh]

When u bound to table/query
the values will be updated in the table immediately on
Form_afterUpdate Event???