Macro can call itself a maximum of 20 times

Hello everybody.

I made a small access program.

When I run a macro I get a error message saying that the macro can only run 20 times. I tried to solve this problem by having one macro calling another macro, but it does not work. Anybody any idea how to solve this problem.

As attched file I send the program in ZIP format. If you want me to send it in not ziped, please tell me. OK how can I send attachements here. I don't see it. So please tell me if you want me to send it to you by mail. My address is bvdhaegen@gmx.de

If you go on record 12 and click on refresh, you'll see the problem poping up.

Thank you all for your help.

This is a new one to me. Why would you want a recursive macro (a macro that calls itself)? There is probably a better way to do whatever it is you are trying to do. If you could describe it to us, we may be able to help find a better solution. If the recursiveness is really necessary and it needs more than 20 iterations, then you will have to do the job in a VBA module.

Instigating a macro or module multiple times consecutively is generally a bad idea, as it eats system resources. Any iteration required should be done via VBA within the module or macro, as asc11 pointed out.