Error When Closing a form

[Mary]

I am getting the following error when closing a form I just made. I get the
error whether I use the button I created or simply clicking the X in the
upper right hand corner of the form. Everything appears to work OK it is just
an anoyance to have to click OK each time I close the form. By the way this
form is opened from another form, if that makes a difference.

"The expression you entered has a function name that Microsoft Office can't
find."

Any ideas what might be causing this? I have checked all of my macros and
buttons but nothing seems to be wrong.

 

[Bill]

Mary,
Does the expression refer to a function that you
created? If so, is it Public and is the containing
module/form currently open?
Bill

 

[Linq Adams via AccessMonster.com]

Another common mistake that causes this is creating a public function in a
standard, free standing module, then giving the module the same name as the
function.