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.