Hiding Combo Box Item (1 Viewer)

OluOlasokan

New member
Local time
Today, 06:12
Joined
Nov 17, 2018
Messages
3
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

MVP / VIP
Local time
Today, 10:12
Joined
Jan 14, 2017
Messages
18,186
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

AWF VIP
Local time
Today, 06:12
Joined
Jan 11, 2013
Messages
3,849
is this what you mean?
 

Attachments

  • cbo.accdb
    452 KB · Views: 40

isladogs

MVP / VIP
Local time
Today, 10:12
Joined
Jan 14, 2017
Messages
18,186
If moke has correctly understood what you meant, I would instead use a multiselect listbox to select your 3 choices
 

OluOlasokan

New member
Local time
Today, 06:12
Joined
Nov 17, 2018
Messages
3
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.
 

Gasman

Enthusiastic Amateur
Local time
Today, 10:12
Joined
Sep 21, 2011
Messages
14,038
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

AWF VIP
Local time
Today, 06:12
Joined
Jan 11, 2013
Messages
3,849
good point Gasman, and correct, although I don't see where any order was requested just best 3.
 

Gasman

Enthusiastic Amateur
Local time
Today, 10:12
Joined
Sep 21, 2011
Messages
14,038
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

AWF VIP
Local time
Today, 06:12
Joined
Jan 11, 2013
Messages
3,849
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
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
 

Users who are viewing this thread

Top Bottom