Adjusting ComboBoxes Dynamically 2

[arrrghhh]

Sorry for the x-post, but I wasn't sure where to post this.

Essentially I have a group of categories, and certain categories have sub-categories. When a general category is chosen that has a sub-category associated with it, I would like a combo box to become visible, and then show a list of the sub-categories that is associated to that category.

I'm sure this is possible, I just don't know where to start. Any help is greatly appreciated, thanks!!

 

[TheAceMan1]

How are ya arrrghhh . . .

Have a look here faq702-4289

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[arrrghhh]

Excellent, thank you! Not sure why I couldn't find that in my search!

 

[arrrghhh]

After looking over that FAQ, I realized I'm not really closer. I'm not sure if it's the FAQ that's too specific and I can't figure out how it applies to our setup, or I'm just retarded and don't know Access. I'm leaning towards #2.

So here's our setup. There's two combo boxes that matter here, and the first combo box should have general trouble items, like "Analog" and "Outbound Dialing". Now not all of them have specific trouble areas, but some do. So sometimes I'll want the combobox displayed, and sometimes I don't.

I couldn't figure out from that FAQ how to apply it to my setup, and it could be the data I have in the table is not organized in a way that is conducive for what I'm doing.

Any help is greatly appreciated, let me know if I'm being too vague. I'm probably trying to do way more than my knowledge of Access allows, but once I get a grip on this piece the rest is pretty much done. Thanks again!!

 

[arrrghhh]

Couldn't figure out how to edit my post. I'm getting closer, but I'm missing something...

I get stuck on the second combo box, the first one is easy, that connects to the table just fine. But when I start putting the code in for the second combo box, I get a weird parameter box that pops up.

I've attached a screenshot of my table, I'm wondering if that's the issue...

I'm trying to do the K.I.S.S. method, but I can't really simplify it more... Thanks all!

 

[arrrghhh]

Sorry, I still don't see how to edit my posts...

To put some perspective - for example, the first combo box feeds on the "Trouble" column. The second combo box, if "Analog" is selected in the first, the stuff under the "Analog" column s/b displayed in the second combo box. Same with if "InboundDialing" is selected in the first combo box, the second should display the column for "InboundDialing".

I'm going to keep plugging away at this FAQ, but I really cannot figure out how to apply it to my setup. Thanks again! Sorry for posting so many times, there really needs to be an "edit post" link!!

 

[jedraw]

Here's a link with a tutorial on combo boxes with examples.
Hope it helps.

http://www.fontstuff.com/access/acctut10.htm

 

[arrrghhh]

Thanks for that link, looks like I'll have a lot more to play with. The more the merrier, maybe out of one of these I can apply it to our situation.

I'll take a look at it in-depth tomorrow... unfortunately I got pulled onto another issue, can't look at this ATM. Thanks again!!

 

[TheAceMan1]

arrrghhh . . .

How about a serious tutorial to pump you up! Combo Boxes 2 (linking two combo boxes)

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[arrrghhh]

Wow, after a ton of wrestling I finally have something that's functional! Thanks so much AceMan, I can't believe something that seemed so easy could be so difficult for me! Thanks again tho!

 

[arrrghhh]

Well now I'm confused... I pushed the updates to our ticketing system, and now the combo boxes work... but when I switch records, the combo boxes stay the same. All the other fields update based on what record I'm on, but the two boxes I made dependent on each other now stick no matter what record I'm on... other than that, it's working as I want it!

What could be wrong? Thanks again!

 

[arrrghhh]

Nevermind!! I'm retarded, the combo boxes were "unbound"... I have A LOT of learning to do with Access, and it's probably better that I figured out most of the issues myself by stumbling through them...

Thanks for the help guys, hopefully I'm done!!