Preventing auto save of main form when setting focus to a sub-form 1

[dhanus]

I have a form with 3 sub-forms from which the user selects informatin to be inserted to the main form.

My problem is that everytime, focus is transferred to any of the sub-forms, data is automatically saved to the table (this is a bound form). I only want the data to be saved when the user clicks the SAVE button.

 

[jgoodman00]

I think you will need to go down the unbound form route if you want to do this, as the save is automatic.

James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures