You cannot call a private function from another form (out of scope). You must make the function Public (to be seen by the entire db), even if it is an event. For instance, if you want a button named cmdVerify to be called from another form, first change it to public,
Public Sub cmdVerify_Click()
Then from the other form, the syntax would be:
Forms!FormName.cmdVerify_Click
Or you could call the other form's Open event by first changing it to public and then using:
Forms!FormName.Form_Open(0)
Just remember that some events have arguments, like the cancel argument on the OnOpen event, so you have to pass the argument to the event.
Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?