Activate "After Update" Event of Combo Box

[jcw5107]

I'm tryin' to speed things up with my d/base by hiding all forms. So far, so good. The problem I'm having is activating the after update event of a combo box on another form. The user will switch between forms, using Visible = true or visible = False. On one form the user uses a combo box to filter records, then when switching to another form, there is another combo box that is used to filter records. How can I get the combo box on the 2nd form to refresh the forms records based on the combo box selection from the 1st form...???
I'm using/passing a global variable around as well - GBLAircraft. The variable is set when the user selects an Aircraft from the combo box....
Any suggestions or examples...???
Thanks in advance..!!
jcw5107

 

[kjv1611]

It sounds like you wouldn't have to activate the "AfterUpdate" event of the 2nd form at all to make this work. Why can't you have the recorsource updated for your 2nd form recordsource updated according to the global variable when it is activated - or whenever the code is sending the form focus from the 1st form to the 2nd form?

--

"If to err is human, then I must be some kind of human!" -Me

 

[jcw5107]

kjv1611,

I don't need to mess with the recordsource..... At at least I don't think..!!

I am passing the variable to the 2nd form:
If IsNull(Me!cboAircraft) Then
Me.Visible = False
Forms!SchdAircraftReview.Visible = True
Else
Me.Visible = False
Forms!SchdAircraftReview!cboAircraft = GBLAircraft
Forms!SchdAircraftReview!cboAircraft.Requery
Forms!SchdAircraftReview.Visible = True
End If

Above is what I am messin' with.. I just can't seem to get it to work...!!!
Thanks for the help..!!
Any other suggestions or examples?
jcw5107