Organising files for beginner.

[rich_bell20]

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.

 

[Zigzag]

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

 

[rich_bell20]

thanks but..

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.

 

[Zigzag]

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