Hi All,

just getting my ahead around VBA for Access 2000. When I try to run some code that's in a particular module, a dialog box comes up that offers me the choice of running some macros, both of which are actually modules I've already written.

What am I doing wrong?

Thanks in advance,

DM

Im not clear what your question is, it offers you a choise of running some macros, can you be more specific?

...what is triggering the macro?
...what is the macro referencing?
...can you provide us a demo?

Danny,

I suspect you mean that when you hit F5 (or hit the "play" button) then the Macro dialog form pops up and it doesnt contain the function/sub you are expecting to run, merely the Macros you have already set up.

Use the Immediate window (Ctrl-G, I think) to start your modules using the sub/function name as you would in code, rather than jumping into the middle of them and hitting F5.

Hope it helps,

Lee

Thanks Lee,

forgot to post an update, I'd realised that was exactly what was happening. I was running code for a function from within the function to test it rather than calling it properly.

Thanks again