List Box not Updating

[Pisteuo]

I initially had a form that included two list boxes. On Click event of the primary list box executed the query ("qrySecondLstBox"). qrySecondLstBox then populated the second list box.

The primary list box after On Click simply read "Me.Requery".

I then changed the primary list box to 4 list boxes within 4 tabs. The second list box was not changed. qrySecondLstBox is still being executed when one of those 4 list boxes are clicked.

After clicking the primary list box I open the query to confirm it has been executed. The data is present and properly filtered per the list box record. However the second list box is not updating anymore. I have even rebuilt the second list box and it still is not working.

Any suggestions?

Thanks.

 

[Mr. B]

Try specifically requering your second list box:

me.NameOfSecondListbox.Requery

Just change "NameOfSecondListbox" to the actualy name of your second listbox.

 

[Pisteuo]

That did not work.

Earlier I tried Me!lstBoxName.Requery

This time I tried Me.lstBoxName.Requery

No luck.

Thank you.

 

[Pisteuo]

Problem fixed with Me!lstBoxName.Requery

Who knows what got fixed. Thanks for the time and trouble though.

 

[Mr. B]

Is your second list box named "lstBoxName"?

 

[Mr. B]

Glad you got it working.

 

[Pisteuo]

I realized that I misunderstood the problem.

I'll post to a new thread.