Filter List Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ann Moller - 09 May 2005 20:42 GMT

I have a combo box that picks a vendor. I have a "list box" that I want to
list all the products for the vendor in my combo box.

I've looked at similar listings but none really answers the how to do this.

Does anyone know how I can structure this with code?

Thanks,
Ann

Reply to this Message

Alex White MCDBA MCSE - 09 May 2005 21:08 GMT

for this to work properly you need to have at least 2 tables

vendor table

vendor_id numeric
vendor_name string
.....

products

product_id numeric
vendor_id numeric
description string

in the on change event for the combo box,

dim SQL as string

SQL = "Select * from products Where vendor_id=" & me.cboVendor.value

me.lstProducts.rowsource = SQL
me.lstProducts.requery

you will have to setup your list box for table/query

hope that answers you question.

Signature

Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

>I have a combo box that picks a vendor. I have a "list box" that I want to
> list all the products for the vendor in my combo box.
[quoted text clipped - 6 lines]
> Thanks,
> Ann

Reply to this Message

Ann Moller - 09 May 2005 23:25 GMT

That Did it. THANK YOU SO MUCH!!

Reply to this Message