Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-17-2018, 03:45 AM   #1
OluOlasokan
Newly Registered User
 
Join Date: Nov 2018
Posts: 3
Thanks: 2
Thanked 0 Times in 0 Posts
OluOlasokan is on a distinguished road
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

OluOlasokan is offline   Reply With Quote
Old 11-17-2018, 03:50 AM   #2
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,350
Thanks: 92
Thanked 1,811 Times in 1,686 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
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
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 11-17-2018, 04:30 AM   #3
moke123
Me.Dirty=True
 
moke123's Avatar
 
Join Date: Jan 2013
Location: Massachusetts
Posts: 672
Thanks: 0
Thanked 209 Times in 196 Posts
moke123 will become famous soon enough
Re: Hiding Combo Box Item

is this what you mean?
Attached Files
File Type: accdb cbo.accdb (452.0 KB, 8 views)

moke123 is offline   Reply With Quote
The Following User Says Thank You to moke123 For This Useful Post:
OluOlasokan (11-17-2018)
Old 11-17-2018, 04:58 AM   #4
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,350
Thanks: 92
Thanked 1,811 Times in 1,686 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
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
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
OluOlasokan (11-17-2018)
Old 11-17-2018, 06:01 AM   #5
OluOlasokan
Newly Registered User
 
Join Date: Nov 2018
Posts: 3
Thanks: 2
Thanked 0 Times in 0 Posts
OluOlasokan is on a distinguished road
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.
OluOlasokan is offline   Reply With Quote
Old 11-17-2018, 02:40 PM   #6
moke123
Me.Dirty=True
 
moke123's Avatar
 
Join Date: Jan 2013
Location: Massachusetts
Posts: 672
Thanks: 0
Thanked 209 Times in 196 Posts
moke123 will become famous soon enough
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
moke123 is offline   Reply With Quote
Old 11-18-2018, 03:08 AM   #7
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,701
Thanks: 317
Thanked 425 Times in 410 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about
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.?

__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is offline   Reply With Quote
Old 11-18-2018, 04:30 AM   #8
moke123
Me.Dirty=True
 
moke123's Avatar
 
Join Date: Jan 2013
Location: Massachusetts
Posts: 672
Thanks: 0
Thanked 209 Times in 196 Posts
moke123 will become famous soon enough
Re: Hiding Combo Box Item

good point Gasman, and correct, although I don't see where any order was requested just best 3.
moke123 is offline   Reply With Quote
Old 11-18-2018, 04:46 AM   #9
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,701
Thanks: 317
Thanked 425 Times in 410 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: Hiding Combo Box Item

Quote:
Originally Posted by moke123 View Post
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 ?
__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is offline   Reply With Quote
Old 11-18-2018, 05:40 AM   #10
moke123
Me.Dirty=True
 
moke123's Avatar
 
Join Date: Jan 2013
Location: Massachusetts
Posts: 672
Thanks: 0
Thanked 209 Times in 196 Posts
moke123 will become famous soon enough
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

moke123 is offline   Reply With Quote
Reply

Tags
hiding combo box items

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding Combo Box Items Weekleyba General 28 03-03-2017 11:41 AM
hiding a field based on chosen value in combo box icemonster General 4 02-16-2010 04:55 PM
Hiding a text box depending on a combo selection tacieslik General 2 03-26-2003 01:56 AM
hiding combo box arrow hyousef Forms 4 03-20-2002 05:42 AM
Hiding Combo box on form Chosin01 Forms 7 06-24-2001 12:37 PM




All times are GMT -8. The time now is 08:57 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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