Hello,

I have a procedure inside a form called "MyProcdure".  How do I call this
procedure from the "On Click" event?  I tried "=MyProcedure" and
"=MyProcedure()".  When I do, I get the error that "Access can't find the
macro '=MyProcedure()" .

--
Thanks in advance,

Steven

hello Steven
in the propertysheet of the commandbutton, select "event
procedure" from the drop-down list and then click the
three dots(...) to the right
this will take you inside the OnClick event in which you
can call whatever procedure you want:

Private Sub Command0_Click()
MyProcedure
...
End Sub

hope this helps
Erez.

tried "=MyProcedure" and
that "Access can't find the

If you're typing the function call directly into the
control's OnClick property then it's

        =MyProcedure()

But, note that it must be a function, not a sub.

If you're calling your procedure from within the control's
Click event procedure, then use

        xx = MyProcedure()

if it's a function and you want to use its return value.  If
you don't want to use the return value or if it's a sub,
then just use:

        MyProcedure

--
Marsh
MVP [MS Access]