List Box Not Updating when main form is changed

[TL_Reed]

I have a list Box on a main form that shows lines of data related to the main form. When I select next record the Main Form changes as expected but the List Bix does not update to show the data related to record 2. I have tried using
Private Sub MyCombo_AfterUpdate()
Me.lstMyListBox.Requery
End Sub

With no success....

 

[theDBguy]

Hi. Try the same code in the Form's Current event.

 

[TL_Reed]

Okay I assume its on the main form "Current" event and the code should be
Private Sub List99_AfterUpdate()
Me.lstList99.Requery
End Sub

Where List99 is the name of the List box.

 

[TL_Reed]

Okay I resolved this and it was much easier than I thought.
On the Main Form "Current" event field I just added a Macro in Macro Builder that refreshes the Form.

 

[theDBguy]

Okay I resolved this and it was much easier than I thought.
On the Main Form "Current" event field I just added a Macro in Macro Builder that refreshes the Form.

Hi. Glad to hear you got it sorted out. Good luck with your project.