Embedded Macro Test Strategy

[bginhb]

Does anyone know a good way of testing embedded macros?



When you are building or reviewing the macro, Access does not permit access to any other part of your database and there are lots of reasons why it would be nice to have that ability.

The only help I have found is to have the VB window open so I can check the value of variables and test expressions while I'm building the macro conditions.

Any thoughts would be helpful.

Thanks ...

[June7]

I don't use macros, embedded or otherwise, because they are harder to debug and I was tutored straight to VBA. When I view a macro it just doesn't look like code, harder for me to read.