It works fine by itself. However, when I import the form into my existing database I get following error. You can download my database. It's in Access 97 format. (I DON'T HAVE UPPER VERSION OF ACCESS)
"The expression After Update you entered as the even property setting produced the following error: Expected user-defined type, not project.
* The expression may not result in the name of macro, the name of a user-define function, or [Event Procedure].
* There may have been an error evaluating the function, even, or macro.