Skip to main content
Participant
August 27, 2009
Question

How to filter a recordset using a combo

  • August 27, 2009
  • 1 reply
  • 592 views

Hi,

I have almost no experience in ASP bu tI need to develop a small site linked to an access database in order to load data.

So, in my site I've got two combobox or if you prefer List/Menu controls.

It's working ok, I mean, if I choose an option in each combox it filter.

What I need to to have an option in each combobox to not filter, such like an option saying ALL, so if I choose the option ALL in one combobox it would show all records.

I hope I was clear.

Please help.

Thanks.

Marco

This topic has been closed for replies.

1 reply

Lon_Winters
Inspiring
August 28, 2009

Set the value of the All selection to %%. You can also leave it blank and put %% in the default value for the recordset.