I have written a macro that I want to repeat until there are no more records to append (i.e., append zero rows). Is there a way for a condition to be applied to the macro that can detect if no records will be appended to the target table?

I do not know VB and need to do this with macros, queries, tables, and other objects (though I a reasonably familiar with properties and very familiar with expressions)

Thanks!