In the book: Beginning Access 2002 VBA, on page 204:
There is a very simple example of creating a FormA and a FormB and adding some code. I'm using Office 2003 and can't get this to work. My Public procedure is not being recognized by the other Form. Can public procedures be written in Forms, or just in modules?

I've got this worked out if anyone's interested.

I think you have to put the Public statement in a module. (not a class module)

Nashville_Bill

I had to call the Public procedure very explicitly:
formA code: (I renamed the proc. in formB to "Terry")

Private Sub btnTerry_Click()
  'Terry This doesn't work even though Terry is Public
  Form_frmFormB.Terry 'this works
End Sub

I also had some syntax problems with msgBox but is ok now.