Hi all,

Is there any way to detect record updates inside a form and fire off a message when a user closes the form that there are unsaved records? I would like to have a function inside my Music Inventory 2001 Access application that detects any unsaved records and asks the user if they want to save the changed records before the form is closed.

Here are my requirements:

• The message should show up only when the user is about to close a form and there are unsaved record changes
• The function should be able to detect how many unsaved records a form has

Thanks in advance,

Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself

"A Person Who Claims To Be A Flash Junkie Isn't Really A Flash Junkie Unless He Can Prove It"

__________________
Ben Horne
-------------------------
I don\'t want to sound like I haven\'t made any mistakes. I\'m confident I have.

Most likely using FireFox and concocting my next Macromedia Flash project
Snibworks Forums Moderator

Welcome to the New Age

Unless you're using unbound forms, the records will save automatically, so there's no need to prompt the user.

However, if you really want to do some coding, you could always use the property

I am a loud man with a very large hat. This means I am in charge