I have an Access front-end linked to an Access back-end. The FE contains (for our purposes), a login form, a main menu screen, and a Data Entry form which appear in that order when the database is opened. ie. The user opens the db, sees the login form and logs in. Then sees the main form. Clicks a button and sees the Data Entry form. The very weird issue that I’m having is that when I step through the DE form opening procedures, Form_Current runs twice or three times consecutively for the Data Entry form and for the 2 or 3 subforms that are embedded within it. Has anyone ever experienced this? It’s not actually causing problems, but I can’t imagine that it doesn’t hurt my performance. Why should all that code execute more than once? I really can’t see what’s causing it.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Form_Current Executes twice consecutively (Access 2002, SP3)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Form_Current Executes twice consecutively (Access 2002, SP3)
- This topic has 11 replies, 3 voices, and was last updated 20 years, 6 months ago.
Viewing 0 reply threadsAuthorReplies-
WBell
AskWoody_MVP -
WStjuni
AskWoody LoungerNovember 3, 2004 at 5:37 pm #895193Thanks for your response, Wendell. Unfortunately, phasing out the Form_Current event on this form is difficult to do. However, I just did something that seemed to help. In my Form_Open procedure I was setting a filter on the form’s recordset based on a variable that was set when the user logged in. I noticed that the consecutive executions of Form_current were being called when the filter property was changed in Form_Open. I wrote a function to retrieve the value of the variable and created a query which filtered the table by calling the function i.e. the criteria on the ID field is: ALIKE GetLocation & “%”. I removed the code in the Form_Open procedure that set the filter and now it seems to only execute Form_Current once!
-
WScharlotte
AskWoody LoungerNovember 4, 2004 at 12:46 am #895375If you have subforms, you’ll also trigger *their* Current event repeatedly. In fact, the current event normally fires multiple times when the form is loading, which is why it’s always desireable to use a flag or some kind of test of Me.Visible = True in the OnCurrent event before executing anything.
-
WStjuni
AskWoody LoungerNovember 4, 2004 at 12:57 pm #895506Charlotte, I’m sorry for being thick but let me check if I understood. The form_current event fires multiple times while the form is loading. If I put a condition before my code that checks to see if the form is visible, the code will only execute during the last execution of the form_current event?
-
WScharlotte
AskWoody Lounger -
WStjuni
AskWoody LoungerNovember 4, 2004 at 1:29 pm #895525 -
WStjuni
AskWoody LoungerNovember 4, 2004 at 1:29 pm #895526 -
WScharlotte
AskWoody Lounger
-
-
WStjuni
AskWoody LoungerNovember 4, 2004 at 12:57 pm #895507Charlotte, I’m sorry for being thick but let me check if I understood. The form_current event fires multiple times while the form is loading. If I put a condition before my code that checks to see if the form is visible, the code will only execute during the last execution of the form_current event?
-
-
WScharlotte
AskWoody LoungerNovember 4, 2004 at 12:46 am #895376If you have subforms, you’ll also trigger *their* Current event repeatedly. In fact, the current event normally fires multiple times when the form is loading, which is why it’s always desireable to use a flag or some kind of test of Me.Visible = True in the OnCurrent event before executing anything.
-
-
WStjuni
AskWoody LoungerNovember 3, 2004 at 5:37 pm #895194Thanks for your response, Wendell. Unfortunately, phasing out the Form_Current event on this form is difficult to do. However, I just did something that seemed to help. In my Form_Open procedure I was setting a filter on the form’s recordset based on a variable that was set when the user logged in. I noticed that the consecutive executions of Form_current were being called when the filter property was changed in Form_Open. I wrote a function to retrieve the value of the variable and created a query which filtered the table by calling the function i.e. the criteria on the ID field is: ALIKE GetLocation & “%”. I removed the code in the Form_Open procedure that set the filter and now it seems to only execute Form_Current once!
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Cox Communications and Charter Communications to merge
by
not so anon
4 hours, 8 minutes ago -
Help with WD usb driver on Windows 11
by
Tex265
3 hours, 16 minutes ago -
hibernate activation
by
e_belmont
7 hours, 2 minutes ago -
Red Hat Enterprise Linux 10 with AI assistant
by
Alex5723
10 hours, 49 minutes ago -
Windows 11 Insider Preview build 26200.5603 released to DEV
by
joep517
13 hours, 54 minutes ago -
Windows 11 Insider Preview build 26120.4151 (24H2) released to BETA
by
joep517
13 hours, 56 minutes ago -
Fixing Windows 24H2 failed KB5058411 install
by
Alex5723
17 hours, 6 minutes ago -
Out of band for Windows 10
by
Susan Bradley
18 hours, 39 minutes ago -
Giving UniGetUi a test run.
by
RetiredGeek
1 day, 1 hour ago -
Windows 11 Insider Preview Build 26100.4188 (24H2) released to Release Preview
by
joep517
1 day, 9 hours ago -
Microsoft is now putting quantum encryption in Windows builds
by
Alex5723
1 day, 7 hours ago -
Auto Time Zone Adjustment
by
wadeer
1 day, 13 hours ago -
To download Win 11 Pro 23H2 ISO.
by
Eddieloh
1 day, 11 hours ago -
Manage your browsing experience with Edge
by
Mary Branscombe
15 hours, 58 minutes ago -
Fewer vulnerabilities, larger updates
by
Susan Bradley
4 hours, 24 minutes ago -
Hobbies — There’s free software for that!
by
Deanna McElveen
10 hours, 48 minutes ago -
Apps included with macOS
by
Will Fastie
8 hours, 40 minutes ago -
Xfinity home internet
by
MrJimPhelps
5 hours, 27 minutes ago -
Convert PowerPoint presentation to Impress
by
RetiredGeek
1 day, 6 hours ago -
Debian 12.11 released
by
Alex5723
2 days, 10 hours ago -
Microsoft: Troubleshoot problems updating Windows
by
Alex5723
2 days, 14 hours ago -
Woman Files for Divorce After ChatGPT “Reads” Husband’s Coffee Cup
by
Alex5723
1 day, 17 hours ago -
Moving fwd, Win 11 Pro,, which is best? Lenovo refurb
by
Deo
6 minutes ago -
DBOS Advanced Network Analysis
by
Kathy Stevens
3 days, 7 hours ago -
Microsoft Edge Launching Automatically?
by
healeyinpa
2 days, 21 hours ago -
Google Chrome to block admin-level browser launches for better security
by
Alex5723
19 hours, 35 minutes ago -
iPhone SE2 Stolen Device Protection
by
Rick Corbett
3 days, 2 hours ago -
Some advice for managing my wireless internet gateway
by
LHiggins
2 days, 9 hours ago -
NO POWER IN KEYBOARD OR MOUSE
by
HE48AEEXX77WEN4Edbtm
1 day, 11 hours ago -
A CVE-MITRE-CISA-CNA Extravaganza
by
Nibbled To Death By Ducks
3 days, 19 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.