If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Dropdown choice eliminated from selections
I have a simple scenario...
We have a list of 20 items and I'd like people to identify the top 10 to them. I created a dropdown but was wondering if I can make it so that when they used one of the rankings if it can be removed from the choices. |
#2
|
|||
|
|||
Dropdown choice eliminated from selections
Erinayn wrote:
I have a simple scenario... We have a list of 20 items and I'd like people to identify the top 10 to them. I created a dropdown but was wondering if I can make it so that when they used one of the rankings if it can be removed from the choices. Say you have two tables tblItems(ItemName) and tblChoices(PersonID, ItemName, Rank) You need to set the rowsource of your combobox to SELECT tblItems.ItemName FROM tblItems LEFT JOIN tblChoices ON tblItems.ItemName = tblChoices.ItemName WHERE tblChoices.PersonID = Me.cboPersonID AND tblChoices.ItemName IS NULL ORDER BY tblItems.ItemName -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
#3
|
|||
|
|||
Dropdown choice eliminated from selections
Erinayn wrote:
I have a simple scenario... We have a list of 20 items and I'd like people to identify the top 10 to them. I created a dropdown but was wondering if I can make it so that when they used one of the rankings if it can be removed from the choices. Say you have two tables tblItems(ItemName) and tblChoices(PersonID, ItemName, Rank) You need to set the rowsource of your combobox to SELECT tblItems.ItemName FROM tblItems LEFT JOIN tblChoices ON tblItems.ItemName = tblChoices.ItemName WHERE tblChoices.PersonID = Me.cboPersonID AND tblChoices.ItemName IS NULL ORDER BY tblItems.ItemName -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
Thread Tools | |
Display Modes | |
|
|