filtering using 2 combo boxes

[Aravind]

Hi folks.

I am doing a library system, and I have a form that diplays the full
history of who has borrowed what book for how long, etc. In that form,
there are 2 unbound combo boxes, "Select Member" and "Select Book". If
I select a name from "Select Member", the history is filtered to show
the borrowing history of that particular member, and the same applies
to choosing a book from "Select Book". I cannot, however, do both at
the same time. I want to be able to choose a member, which will
display the history of that member, and then further refine the
displayed history by choosing a book from "Select Book", so that the
form will show if that particular member has borrowed that particular
book before. Does anyone have any suggestions? Thank you.

[David]

Just grabbed this from one of my apps which does what you want
You will need to change the names to suit
SELECT [eventDate], [customerid]
FROM SundrySaletbl
WHERE ([Forms]![SundrySalefrm]![evdatecmb] Is Null or
[eventDate]=[Forms]![SundrySalefrm]![evdatecmb]) And
([Forms]![SundrySalefrm]![selectcustcmb] Is Null or
[customerid]=[Forms]![SundrySalefrm]![selectcustcmb]);
HTH
David B

Aravind <so**********@hotmail.com> wrote in message
news:61*************************@posting.google.co m...

Hi folks.

I am doing a library system, and I have a form that diplays the full
history of who has borrowed what book for how long, etc. In that form,
there are 2 unbound combo boxes, "Select Member" and "Select Book". If
I select a name from "Select Member", the history is filtered to show
the borrowing history of that particular member, and the same applies
to choosing a book from "Select Book". I cannot, however, do both at
the same time. I want to be able to choose a member, which will
display the history of that member, and then further refine the
displayed history by choosing a book from "Select Book", so that the
form will show if that particular member has borrowed that particular
book before. Does anyone have any suggestions? Thank you.