Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Forms (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=9)
-   -   Hiding Combo Box Item (https://www.access-programmers.co.uk/forums/showthread.php?t=302476)

OluOlasokan 11-17-2018 03:45 AM

Hiding Combo Box Item
 
I have a combo box based on table MemberAtrib with nine attributes. I want user to select their best three attributes. The selections will go into txtAtrib1, txtAtrib2, and txtAtrib3. My first question is can I use one combo box to accomplish this task?

If I have to use cascading combo boxes, cboAtrib1, cboAtrib2 and cboAtrib3, How can I hide the selected item in cboAtrib1 from cboAtrib2; and selected items in cboAtrib1 and cboAtrib2 from cboAtrib3. In short cboAtrib2 will have 8 items and cboAtrib3 will have 7 items.

I hope my explanation is explicit. Thanking you for your help!

OluOlasokan

isladogs 11-17-2018 03:50 AM

Re: Hiding Combo Box Item
 
Sorry but this is confusing.
What do you mean by attributes? Separate fields? Different values in the same field?
It sounds like you may be using a spreadsheet structure which doesn't work well in Access

moke123 11-17-2018 04:30 AM

Re: Hiding Combo Box Item
 
1 Attachment(s)
is this what you mean?

isladogs 11-17-2018 04:58 AM

Re: Hiding Combo Box Item
 
If moke has correctly understood what you meant, I would instead use a multiselect listbox to select your 3 choices

OluOlasokan 11-17-2018 06:01 AM

Re: Hiding Combo Box Item
 
Moke123 hit my issue right on the head. It's a home run. I will look into isladogs' recommendation as well.

Thank you people! You're great.

moke123 11-17-2018 02:40 PM

Re: Hiding Combo Box Item
 
I agree with Colin on the Multi-select list box which was my first thought also. I just happened to try the combos first and it worked well.

If you want to try the list boxes take a look at the sample I posted in an earlier thread https://access-programmers.co.uk/for...4&postcount=12

Gasman 11-18-2018 03:08 AM

Re: Hiding Combo Box Item
 
PMFJI,
My reading of this thread was to put the attributes in order or preference?
How would one do this with a multi select list box.?

moke123 11-18-2018 04:30 AM

Re: Hiding Combo Box Item
 
good point Gasman, and correct, although I don't see where any order was requested just best 3.

Gasman 11-18-2018 04:46 AM

Re: Hiding Combo Box Item
 
Quote:

Originally Posted by moke123 (Post 1599647)
good point Gasman, and correct, although I don't see where any order was requested just best 3.

Reading it again, i think that will be indicated by the textboxes, 1, 2 & 3 ?

moke123 11-18-2018 05:40 AM

Re: Hiding Combo Box Item
 
Again I agree that's possible or its just the way he's storing three values (which could also be an issue)

we actually didnt answer his question
Quote:

My first question is can I use one combo box to accomplish this task?
which the answer would be yes, with a multi-select combobox, but i wouldnt recommend that.

I think we need to hear from the OP


All times are GMT -8. The time now is 05:18 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World