Is this really a macro or is it code? I've heard of using the 'step through' function of a macro, but never heard of putting break points in a macro - only in a procedure in a module.
If it's code, put your break at the start and F8 single step through it. Whatever condition you expect to exist in the section where you're putting a break probably isn't the case, thus the code doesn't execute as you expect. If it's really a macro, excuse my ignorance as I'm a bit behind in Access versions.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.