Solved What event occurs when user moves to new record on main form and subform updates the list of it's records? (1 Viewer)

[slharman1]

What event occurs when user moves to new record on main form and subform updates the list of it's records?
In other words:
If move move to another parent record on a form, is there an event that is triggered in either the subform or main form?

 

[theDBguy]

The Current event of the main form fires. I'm guessing the Current event of the subform fires too.

 

[slharman1]

The Current event of the main form fires. I'm guessing the Current event of the subform fires too.

Thanks

 

[The_Doc_Man]

The question also applies as to whether either form was or wasn't dirty, since a dirty form does a behind-the-scenes update, which means there will also be BeforeUpdate and AfterUpdate events. Here is a more detailed explanation.

Order of events for database objects - Microsoft Support

support.microsoft.com

The detailed description of form/subform event behavior is in the lower portion of the referenced page.

 

[561414]

When interacting with forms or controls, various events can be triggered based on your actions. These events encompass control events such as Exit, LostFocus, Enter, GotFocus, and Click, among others. Additionally, there are form events like Current, Before/After Update/Insert, and even mouse movements. The specific events that occur depend on your layout and the state of your form.

For example, let's say you had the focus on a main form control, such as a textbox, before entering a subform control. If you then return to the main form by clicking on another control, like a combobox or another textbox, a different set of events will be triggered. Furthermore, the version of Access you're using will also impact which events are fired.

To accurately determine which events are being triggered and their order of execution, it is best to initialize all relevant events and have them print their names. Here's an example:

Private Sub Form_Current()
Debug.Print "Form_Current"
End Sub

It may not be necessary to do this for all events, such as mouse movement events.

 

[Pat Hartman]

Hi Steve,
Here is a link to a database that you might find helpful. It logs form and some control level events so you can see what happens. There are two videos that might help to understand how to best use the database. Modify the forms or add your own to see how they work.

Bad Data is Bad for Business #1 and #2

I just added #2 --- that link is further down. It is much shorter than #1. I also added a copy of the database I used for the video. Enjoy:) I created a database to help people to understand how and why to use the Form's BeforeUpdate event to validate data. @Uncle Gizmo and I made a...

www.access-programmers.co.uk