How do I run vba code in Access without a macro window opening?

[mb1946]

I am brand new to Access 2007 VBA programming. When I try to run simple test
VBA code, a window pops up asking for a macro name.

What am I doing wrong and how can I get around this?

 

[Stuart McCall]

I am brand new to Access 2007 VBA programming. When I try to run simple
test
VBA code, a window pops up asking for a macro name.

What am I doing wrong and how can I get around this?

What's the code and how are you trying to run it? (there are several ways)

 

[Paul S]

Try the "immediate window..."

What's the code and how are you trying to run it? (there are several ways)

 

[Lincoln]

Your VBA code has to generate an output. Place a debug.print "place an output
variable name"; without the quotes of course and open the Immediate Pane by
selecting Ctl-G.

You should see your output in the Immediate Pane. If nothing happens then
your code may require calling the function from a query, or some other higher
level object.