Im stuck with my combo box...please help with just one.

[Jakboi]

I am having difficulties with combo boxes for some reason and cant get it to work. I have spent this week 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.

----------------------------------
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.

 

[Scottyk537]

I think this is what your tring to do.....
If it was, you were making it way more complicated than it had to be.
See your attached updated DB.....

Do you understand this?

 

[Jakboi]

THANK YOU so much. I am still looking at what you did so I can understand it, but have another question. In the frmMemberDetails, that works great with the drop down boxes....however when I go to move to the next record...it keeps giving me:

"The value you entered isnt valid for this field"

Tried changing numerous items. I looked at bound columns, field formats and such but no luck. Tried to see if it only happend when it was blank and whether or not it was required field.

Tried changing the queries you made and the control bound for the second field. I am kinda fishing around for what could be causing it.

It doesnt happen till I reach client number 4.....hmmm

Any Ideas?

 

[Groundrush]

THANK YOU so much. I am still looking at what you did so I can understand it, but have another question. In the frmMemberDetails, that works great with the drop down boxes....however when I go to move to the next record...it keeps giving me:

"The value you entered isnt valid for this field"

Tried changing numerous items. I looked at bound columns, field formats and such but no luck. Tried to see if it only happend when it was blank and whether or not it was required field.

Tried changing the queries you made and the control bound for the second field. I am kinda fishing around for what could be causing it.

It doesnt happen till I reach client number 4.....hmmm

Any Ideas?

Check the data type in your table
it may be a field that's set to Text instead of a number & visa versa

 

[Jakboi]

Ok think I found it. The column needs to be converted from the old "Preliminary, etc" to the "numbers", like so:

It seems to stop after I reselect what is there. That should do, now time to finish this section. Hopefully I should be able to understand it better.

Thanks for all the help here.

 

[Jakboi]

Ok thought I had it, but have another issue.

When I select the classification in Client Information it works just fine. However on the list in and in the database it uses the ID and not the words. I have tried everything, and dont know why it is doing this.

It is the only one that is putting in the ID instead of the words or other column. Have attached some screen shots for help.

Anyone know where I should be looking to fix this....?

Thanks.

 

[mtairhead]

Your combo box is saving an assigned value, rather than the actual text representation, in the record. It saves space, and makes for a cleaner, more stable database. Change the "bound column" in the properties of the combo box, if you want to prevent this from happening.

 

[Jakboi]

Your combo box is saving an assigned value, rather than the actual text representation, in the record. It saves space, and makes for a cleaner, more stable database. Change the "bound column" in the properties of the combo box, if you want to prevent this from happening.

Thank you for the response. That does take care of this, making the ID appear as the text, but it also makes this dropdown box not work.

I have then tried to change this to several different things with no success. I have tried to change the bound to on that column but am stuck.

Seems as if the Clarification dropdown is dependent on what the Classification dropdown is bound to.

I will see what I can play with or take any ideas what makes the Clarification box dependent on what the Classification is bound too.