I am doing an export routine that involves all of the user generated tables (meaning no MM framework tables get exported.)

I want to ensure that the user does not have any open forms before starting the export routine.

At first I was going to loop through all the tables and check the status of 'used' but there are often open tables in the app even if they are not currently being used by a form.

Any suggestions on doing this?

The only thing I don't want is for a user to leave a form open somewhere, then export the data that is being used in the form (exporting it also deletes the data) and the form then crashes or suddenly looks empty to the user.

If there is a formcount property or something like that of the app object, could I just ensure that this is at zero before starting?

Thanks,

Greg