By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,376 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

filtering using 2 combo boxes

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.