Loops in macros

[Atomic Shrimp]

Is it possible to have a loop in a macro;

I've taken over development of somebody else's project (Never do this!) which is all queries & macros (I would have done it in VBA), and I need to carry out a function repeatedly until a condition is true; I could redesign the whole database, but I'm hoping for a 'quick fix' in the meantime.

Mike

 

[Shlomo Levi]

once you are in Design View Click on View from the menu and choos condition this will add a new column. In there you should be able to build the condition.
now If I was to do it I will convert all the macros to VBA this way you can control the loop.
Have fun

 

[Atomic Shrimp]

Thanks

the conditions column is already there (some of the macro commands are conditional already)

Good Idea about converting to VBA, although actually on thinking about it, all I need to do is test for the condition in VBA then Docmd.Runmacro from there.

Mike