Make Your Microsoft Dynamics Investment Count & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.
Course Of The Month
4 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS Access 2003 Subform event
Posted on 2012-12-28
I have a main form (datsheet view) and a subform(also dataseheet view)
Lets say I expand the main form and then expand the subform
When I now click OFF of the subform by clicking in the main form...what event is that?
Form unload?
Lost Focus?
Lets say I expand the main form and then expand the subform
When I now click OFF of the subform by clicking in the main form...what event is that?
Form unload?
Lost Focus?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
3
7 Comments
Active 6 days ago
Please clarify what is mean by "expand" the forms?
There may be a few events that may actually fire in this case (not just one):
(No in any particular order)
BeforeInsert
AfterInsert
BeforeUpdate
AfterUpdate
Unload
LostFocus
OnExit
OnError
...etc
...and depending on what happened while the form was opened, the order may change
To be sure, put a messagebox on all the form events to see which ones trigger for your specific environment, and each user scenario.
As always, specifying the need for this, and your ultimate goal here, ...is always a big help in getting you the most fitting solution.
;-)
JeffCoachman
There may be a few events that may actually fire in this case (not just one):
(No in any particular order)
BeforeInsert
AfterInsert
BeforeUpdate
AfterUpdate
Unload
LostFocus
OnExit
OnError
...etc
...and depending on what happened while the form was opened, the order may change
To be sure, put a messagebox on all the form events to see which ones trigger for your specific environment, and each user scenario.
As always, specifying the need for this, and your ultimate goal here, ...is always a big help in getting you the most fitting solution.
;-)
JeffCoachman
Active today
JeffCoachman
I'll take a look at that from home tonight.
Believe it or not...they cut us some slack and the programmers can leave an hour early today!
I'll take a look at that from home tonight.
Believe it or not...they cut us some slack and the programmers can leave an hour early today!
Active 6 days ago
<they cut us some slack and the programmers can leave an hour early today>
I'm in NY and I have to stay 15 more minutes till 5PM...
I'm in NY and I have to stay 15 more minutes till 5PM...
Active today
boag2000
You just gave me a clearer understanding of the process.
I placed a messagebox on every type of event and walked my way through a series of issues. (Inherited)
This database has a load of VBA that switches back on itself and I'm removing duplicate code.
You just gave me a clearer understanding of the process.
I placed a messagebox on every type of event and walked my way through a series of issues. (Inherited)
This database has a load of VBA that switches back on itself and I'm removing duplicate code.
Featured Post
Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability.
Flipping Coins in Excel: Enter =RAND() into cell A2:
Recalculate the random variable…
Suggested Courses
Course of the Month4 days, 19 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.