Thanks Stewart,
I'll probabaly convert this to VBA at a later date. For now I've found an quick interim solution to controlling macros in access 2007 via the condition column in the macro design page. I put this in the condition column:
[Reports]![StatusRpt]![Status Indicator]="Started"
Which reads a value from a table as defined by the report. If it = Started or if it = Done I can trigger the Macro to do different...

We have a Macro that runs many queries and we want to force it to abort based on the values we find in the database. Any ideas on the best method for doing this?

More details: The database is being populated by another system so we want to make sure that their update finished. If we set up a table with a status value in it then we can just read that table and see if their update finished properly. If so then the macro can run all of...