Stoping Macro on last record

[EddCase]

Hi All,

I'm trying to run a macro which loops going to each record on a form. I know i can run a macro within a macro and use the repeat count & repeat expression. Using the repeat count isn't an option as I cannot be sure how many records I have at any one time. I would like to use the Repeat expression option, to stop the macro when it reaches the last record, but i am unable to figure out a way to do it, any ideas?​

Thank you in advance

Edd

 

[TedMartin]

Post your code here and we shall see.