Change List Box Row Source using combo box

[dntel123]

Just wondering if it is possible to change a List Box Row Source Using the OnClick Event of a Combo Box.

So for example, I have 4 options in a combo box: And when i click each one in i'd like the Row Source of say 'lstPopulateRecords' to change to a different Query so then it would therefore populate the listbox with another set of records.

Reason for this is my cmdSelectAll button and DeselectAll button are programmed to one List Box, so this method would make the buttons work for all

Help is greatly appreciated thanks, Liam

 

[pbaldy]

Try

Me.ListboxName.RowSource = "YourQueryName"

 

[dntel123]

Thanks, ill give it a go and let you know, thanks for the reply

 

[mr_e_landis]

I've done this a couple times and it works! As pbaldy said you can just do a

Me.ListboxName.Rowsource = "YourSQLQuery"
me.ListboxName.Requery

Good Luck

 

[pbaldy]

You don't need the requery line. Setting the row source will effectively requery the combo.

 

[mr_e_landis]

Yea you're right... My listbox was well queried

 

[dntel123]

Thanks works great, very nice and efficient way of populating list boxes with different tables