Use a combo box to populate a list box

H

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
 
J

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
 
H

Hank Stalica

Jeff said:
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
Click to expand...
Thanks..that got it...
 
Top