Macro Repeat Expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have a macro run multiple times using the "Repeat Expression"
until a table has zero records. What would be the syntax of the expression?

Thanks
Dave
 
Assuming that you're deleting records from a table as part of the macro's
actions, you could use a DCount function in the expression to test if the
table is empty. If the result of this expression is true,
DCount("*", "NameOfTable") = 0

then the table is empty.
 
Back
Top