2 combo boxes on a form

[Mike Powell]

Hi guys,

A simple one I hope. I have built a purchase order database, and I want to have reports on each category. Can I use one form combo box to give a category, which gives a secon combo box for items. Example Maintenance in tye first box, gives electrical,, or hydraulic etc in the second.

Thanks to anyone who replies.

Mike

 

[jjturner]

Check out the Developer's Solutions db in the Access sample db's for info on how to control contents of 2nd combo based on selection from the 1st combo. One of the form examples uses this method.

HTH,
John

 

[Jack Cowley]

You will also find the answer in this article .

hth,
Jack

 

[Pat Hartman]

Here's a link (I hope) to the solutions.mdb download for A2K. I have trouble bookmarking links to the msdn site so this may work one day but not the next.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bapp2000/html/mdbdownload.asp

 

[skwilliams]

I have a word document explaining cascading combo boxes.

HTH

 

[Mike Powell]

SK
Data base attached.

When you open the Main Purchase form, You will see the category combo box. This houses all the items in my category list. I want to say have a "consumable" category and this would bring up grinding tools , cleaning consumables etc. Your help is very much appreciated.

Its my first attempt at this so excuse the way I've built it !
Mike

 

[skwilliams]

Hi Mike,

I don't see your attachment.

Steve