List Box Updating

[JoanieB]

I may need a combo box, but I'm not sure. I need to link the 'box' to a query that counts the number of instances based on the value of the form that is open (the query behind the list/combo specifies the value of the field on the form) It only shows the count of the first record and never changes (I've tried both types of boxes). How can I get it to change with each record the user moves to? Does it have to do with the bound columns or those things in the properties? I've tried looking in my books and playing around with them, but to no avail!

 

[grtammi]

Hi Joanie ...

When the data on your form changes, your list box data needs to change also - and the way to make your list box data change is to invoke the Requery method on the list box.

i.e. If your list box is named lstMyList ...

...
'your code here
lstMyList.Requery
'more code here
...

And that's all there is to it.

HTH

Greg

When you don't understand, just nod and smile.

 

[JoanieB]

That was great! But I have a question: can I only do this within the code behind the form? The users will be jumping around alot and using the find button on the toolbox to locate certain records. If I can only requery within the code (next, previous buttons, etc), we may run into probs.

 

[grtammi]

Try using the forms OnChange event also ...

 

[JoanieB]

That's the On Current event behind the form, right? I think that's it! Thank you.