John,

In the destroy event of the form I make a method call that loops through all open buffered tables or views that will prompt the user if a record has been modified but not committed. Although the code is specific to my form I don't think it would be hard to write a generic routine that could be called from any form by inserting into the base class of the form.

Randy