Can't Run Sub

[jegenes]

I've converted a 2000 database to 2007 and most of it seems to work okay. It's a small db, with 1 table, not very many queries or macros, etc.

I'm just trying to debug a couple of small glitches and cannot get the "Run/Sub" to run in the code window. It keeps giving me a "Macro" window, where I'm supposed to type in the name of the macro to run. Also, "Compile" is greyed out. If I try "Step Into..", no luck, either.

Access Help says this:

"Run Sub/UserForm:
Runs the current procedure if the cursor is in a procedure or runs the form if a form is currently active. This command becomes the Continue command when you are in break mode.
If neither Code window nor UserForm is active, this command becomes the Run Macro command."​

I'm definitely in the Code window, but it keeps giving me the "Run Macro" command. I'm out of ideas.... Thanks.

john

 

[aikea]

You need to place you sub in a module. If it is in a form, it won't work.

This happen since Access 2002.

 

[jegenes]

Thanks a lot. I'll give that a go.

--john