How to filter if i have multiple record using combo box?

[Jeremy Sng]

Hi everyone,

How can i filter when i have multiple record?

Eg.

Brand:

Nike
Nike


Puma
Adidas
Adidas

In the combo box(Drop down Box) i want to have only,

Nike
Puma
Adidas

When i click 'nike' it will filter out puma & adidas.

How can i do this filtering?

[davegri]

What's the rowsource of your combobox?

[Jeremy Sng]

SELECT tblshoe.P/N, tblshoe.brand From tblshoe where (((tblshoe.brand)=[forms]!frmshoe]![cbobrand]));

[davegri]

reply later.....

[davegri]

You need a new table, tblBrands, that contains all possible brands.
That will be the rowsource for your combobox.

Now what do you want to happen when you choose an item in the combobox?

[Jeremy Sng]

Hi Davegri,

Sorry for late reply.

Now I want to filter away other sports brand

Example:

I select 'Nike' only nike brand will appear out.

How can I do this?

[Jeremy Sng]

Will I need to program the combo box?

[davegri]

This little DB shows how.
Attachment 28223