Use a combo box to populate a list box

[Hank Stalica]

What I want to do is select an item from a combo box and then have it
run a query that populates a list box. Is that possible? If so, how do
I do it?

Thanks..

--Hank

 

[Jeff Boyce]

Hank

If you set the source of your listbox to a query that uses the combo box's
value as a selection criteria, the only change you'd need to make is to add
a ".Requery" to the combo box's AfterUpdate. Something like the following
line:

Me!lstYourListBox.Requery

Good luck

Jeff Boyce
<Access MVP

 

[Hank Stalica]

Hank

If you set the source of your listbox to a query that uses the combo box's
value as a selection criteria, the only change you'd need to make is to add
a ".Requery" to the combo box's AfterUpdate. Something like the following
line:

Me!lstYourListBox.Requery

Good luck

Jeff Boyce
<Access MVP

Thanks..that got it...