Combo Box and selection of item in that list.

[Jakboi]

Combo Box Help - Confused.

Hello,

Didnt know where to start or what direction to head in. I have a combo box on one of my forms. It works fine, but would am looking for an added feature.

I am looking to get the following started:

There are 5 items in the list of my combo box. If the user selects the item called "Lost Opportunity", then how do I get an additional combo box to show up underneath it with reasons the sales opportunity was lost.

Then the reasons why would be in the additional box and they would have to select one...my work wants it so that if they lose the sale, they must provide a reason for that loss of business.

Any help in a direction would be appreciated.

Thanks.

 

[ColinEssex]

search for "cascading ComboBoxes"

Col

 

[Jakboi]

Hello, thank you.

I found this in a sample and wondering if I am on the right track since I am not that good with this.

Private Sub Classification_AfterUpdate()

        Me.lblResult.Visible = True
        Me.txtResult = "LOST OPPORTUNITY"
      ' Requeries the bottom combo (cboReason)
        Me.cboReason.Requery

End Sub


Private Sub cboClassification_BeforeUpdate(Cancel As Integer)

End Sub

Private Sub cboReason_AfterUpdate()

Me.lblResult.Visible = True
Me.txtResult = Me.cboReason.Column(1) & ", " & Me.cboClassification.Column(1)

End Sub

It doesnt seem to work, but not sure if I am heading towards my goal or just off on a tangent. I found this and swapped out the names for my boxes. Does "lbl" obvioulsy stand for label?

Thanks for any continued assistance.

 

[Jakboi]

I seem to running into issues. I have been trying to get this to work all day and several times...while attempting to change things and get it to work...it freezes on me.

Access menus and actually everything becomes unuseable. Any know why this is happening as so I can not do it anymore.

I then have to copy the form from a copy to get it to work again.

Thanks.

 

[Jakboi]

I am having difficulties with combo boxes for some reason and cant get it to work. I have spent the last couple of days trying to use examples found here and other places but still not successful.

Have looked at the examples on font stuff and have downloaded various examples here on these forums.

If anyone can help set this one up for me, then I can use it for a model for the rest, just not sure how to setup initially. Even if you get me closer to what I am now.

I thought I came close yesterday, but the combo boxes didnt change the records in the database after choosen.
-----------------------------------
I need the classification drop down box on the member details form to prompt the secondary box choices. Initally if someone chooses "Lost Opportunity" in the classification then the reasons why need to be available in the second box. When choosen they need to be saved in the database. I have tables setup for classification (tblClassification) and for reasons (tblLostopportunityreasons). If anyone at all can help set this up I would soooooo appreciate it.

Refer to first post as well.
----------------------------------
Then I can use this to help me do others that I need to do. I am looking for this one xmas present since I am stuck and my understanding of Access is rather new.

Thanks.