I can't find the Assign Macro command
 

I am trying to assign a Macro that I recorded to a command button. However
when I right click on the sizing bar of the command button "Assign Macro"
does not appear. Is thare another way to do this?

I can't find the Assign Macro command
 

You used a commandbutton from the Control toolbox toolbar.

Delete that one and add a button from the Forms toolbar.

Dave wrote:

I am trying to assign a Macro that I recorded to a command button. However
when I right click on the sizing bar of the command button "Assign Macro"
does not appear. Is thare another way to do this?

--

Dave Peterson

I can't find the Assign Macro command
 

I'm not sure if there is anything against doing this (as I've been doing it
this way for some time), but you can go to 'View Code' and then just type
the name of your macro. That should run your macro when the button is
clicked.

HTH,
Paul

"Dave Peterson" wrote in message
...
You used a commandbutton from the Control toolbox toolbar.

Delete that one and add a button from the Forms toolbar.

Dave wrote:

I am trying to assign a Macro that I recorded to a command button.
However
when I right click on the sizing bar of the command button "Assign Macro"
does not appear. Is thare another way to do this?

--

Dave Peterson

I can't find the Assign Macro command
 

Personally, I like the buttons/controls from the Forms toolbar for most things.
I find that they're "lighter" than their counterparts from the control toolbox
toolbar.

PCLIVE wrote:

I'm not sure if there is anything against doing this (as I've been doing it
this way for some time), but you can go to 'View Code' and then just type
the name of your macro. That should run your macro when the button is
clicked.

HTH,
Paul

"Dave Peterson" wrote in message
...
You used a commandbutton from the Control toolbox toolbar.

Delete that one and add a button from the Forms toolbar.

Dave wrote:

I am trying to assign a Macro that I recorded to a command button.
However
when I right click on the sizing bar of the command button "Assign Macro"
does not appear. Is thare another way to do this?

--

Dave Peterson

--

Dave Peterson