Hello all. Would anyone be so kind as to help me out with this beginners problem. I have a lot a books which i'd like to sort into categories. I'd like to be able to select a category from a combobox on a form, and for relevant books in that category to appear in a listbox. Upon clicking on a particular book on the listbox, relevent info should appear on the form eg. date purchased,author etc.
Is it also possible to have an option to view all books from a particular genre in spreadsheet format embedded in the form, and an option to view every book regardless of genre. I'd then like to be able to print reports on each/all. I'm sure i'd be able to manage if someone could kindly get me on the right path with an example.

Thanks,

Richard.

Hi Richard,

Bob Larsen has been kind enough to set out some examples that might be a good starting point for you, look for "HOW TO CREATE A COMBO BOX TO SEARCH A RECORD".

http://www.btabdevelopment.com/main/QuickTutorials/tabid/55/Default.aspx

Garry

Thanks but this only shows me how to return information on a form based on what i select in a combobox. Id like the information to filter into another combobox or listbox and then show data based on that selection on my form. I do not know how to do this.

Thanks.

Ok then what you are looking for is a "cascading Combo".
Have a search around, you will definately find examples of this.
I will have a mooch later to to see if I can find anything that might help.

Garry