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

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

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