On Current Event when other code closes form?

[Scoob55k]

This question actually began in another thread. To review:

http://www.tek-tips.com/viewthread.cfm?qid=1359644

One more question.

It's working slick right now except for one form in which I have it doing something OnCurrent. It seems to error out because the form has been closed due to the user (me in this case, testing) not having proper security enabled.

I was thinking if putting code in the Procedure I'm calling to look and see if it's this specific form, but not sure how to do that.

Below is the original code. I've tried to bypass it with an if statement, etc., but no goods.

[Staffing] = DCount("Alias", "tblClaimHandlers", "[Team]=[TMteam]")

FYI - [Staffing] is a field on the form

Thanks a million!

 

[Scoob55k]

Not sure if this is why no one answered me, however I found that it works fine when I'm not in design mode of the database. If I just open it to use, it's perfect!

Thanks!