Web Development

Ask something
Discussion Locked

wild On Current call

0 helpful
4 replies

by john_wills

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am having trouble at close of an Access form. I have deduced, and via MsgBox confirmed, that closing the form is somehow invoking the OnCurrent subroutine. I would not expect this, and it does not occur in another database with a fairly similar form. Presumably something in my form is causing DoCmd.Close to trigger OnCurrent. Where should I look?

4 replies

by dklippert

I asume, but have to ask: Have you looked at the Event tab of the Form Properties for an entry in On Current?
Also looked at macros to see if one references the form?

by john_wills

There is an event set for On Current, as there is in the similar form in another database which does not have this problem. I put the subroutine in for a reason, but it does not work right when the form is closing, because then there is nothing current to calculate with.
There are no macros in this database.

This discussion is closed to new replies.