Stop Macro on Last Record in Form

[wdkoseck]

I am lousy at SQL so I use macros.

I have a macro that opens up a form called SLA Complete Form - The macro then goes and examines two fields on the form to see if they contain data and if they do not then it displays a popup box with a message.

The form that gets opened up can have anywhere from one record to approximately a hundred records.

How can I get the macro to stop running when it hits the last record on the form without displaying an error message. I am currently using the next record feature in the macro.



Thanks

Walt

[June7]

Really? SQL is the language of queries and Access has wizards and designers for building queries. Macros, on the other hand, are confusing, harder to debug, and less versatile.

Review: http://forums.aspfree.com/microsoft-...rd-140375.html

I use only VBA, no macros.