Stopping a Macro

[BruceJackson]

I have a macro - M1 with a macro nested within it - M2.

M2 runs an Append query. I want M2 to repeat an infinite no of times until a condition is met. The condition is a query field returning a specific value "0".

How do I do this in M1 using the Repeat Expression box for the M2 macro?

Many thanks,

Tax and MOT.

 

[DoubleD]

I would suggest writing this in VBA instead. Something like this:

Private Function UpdateData()

Do While nz(Dlookup("[QueryField]","QueryName"),1) <> 0
  DoCmd.OpenQuery "AppendQuery"
Loop

End Function

No you can use the RunCode option in Macro 1.

I am what I am based on the decisions I have made.

DoubleD