Requery Works on Record Source, List Box Does Not

[jcruzAME]

So I have a combo box that pulls a list of people.

On one form, I have their clients, which will update as I change the combo box.

On another form, I have a list of their clients as well as information in a list box. I can see the record source update as it will change at the bottom.

BUT, the actual list box won't update until I click onto another tab and come back.

I have tried the listbox.rowsource.requery and it won't update until I come back to the tab. Any suggestions?

 

[boblarson]

It would be

Me.ListBoxName.Requery

not RowSource.Requery.

 

[jcruzAME]

Thanks Bob. That worked. Now my problem is, I'm using a Navigation form. If I'm not on that tab, it will say it can't find subfrmHome.

Is there a way to check what tab I'm on?

Something like If not on TabHome, don't do anything,

Else if on TabHome, requery that list box. And have a requery action on load for the form?

 

[boblarson]

I haven't worked much with the new Navigation in 2010, so I can't tell you what to do there. I would post a new thread specifically dealing with that. I just haven't had time to play around with it much yet.