Conditional statement based on active form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 16 Sep 2005 01:23 GMT

Hello,

I'm trying to write a Macro whereby a keystroke performs differing functions
based on what form I have the focus on. I don't know how to program with
Visual Basic, but I do pretty well with Macros. Can anyone help?

Signature

Mike

Reply to this Message

Steve Schapel - 16 Sep 2005 22:37 GMT

Mike,

Use this type of thing in the Condition for the AutoKeys macros...
[Screen].[ActiveForm].[Name]="YourForm"

Please post back with more details, and examples, if you need more
explicit help.

Signature

Steve Schapel, Microsoft Access MVP

> Hello,
>
> I'm trying to write a Macro whereby a keystroke performs differing functions
> based on what form I have the focus on. I don't know how to program with
> Visual Basic, but I do pretty well with Macros. Can anyone help?

Reply to this Message