Depending on which ID is being referenced in a subform, I want to restrict the list of values in a Combo Box using a query:
• I have a subform [Bonus Subform] that is linked to Table!Bonus.
• I have a query [Bonus ID to valueList] that associates each Bonus ID to a list of values. The way this query looks in Datasheet mode is list of IDs on the left, and usable values on the right. Because each ID can have anywhere from 1 to 20 possible values (depending on another query...details are not important), there are often multiple instances of each ID (Bonus ID 87, for example, has 13 possible values that I want in the combo box, so there are 13 instances of 87 in the left column of this query).
Here's the problem. When I set the row source for the Combo Box to the the query [Bonus ID to valueList], it does not restrict the list to just the current ID. Instead, it lists the possible values for ALL Bonus ID's.
I currently have this Combo Box set up like this:
Name: comboIndMult
Source: indMult (field on Table:Bonus...so what the user selects from this combo will be stored in this field)
RowSource: SQL statement with (column 1)Table:Bonus:bonusID joined to query [Bonus ID to valueList] via bonusID and displaying field (column 2) [valueList].
Column Count: 2
Column Widths: 0";2"
Bound Column: 1
So shouldnt this Combo Box be restricted to ONLY the values with the current Bonus ID?!
I hope this description makes sense. Thanks for any help! I've been tearing my hair out for the last two days over this.
Thanks!
-DK
• I have a subform [Bonus Subform] that is linked to Table!Bonus.
• I have a query [Bonus ID to valueList] that associates each Bonus ID to a list of values. The way this query looks in Datasheet mode is list of IDs on the left, and usable values on the right. Because each ID can have anywhere from 1 to 20 possible values (depending on another query...details are not important), there are often multiple instances of each ID (Bonus ID 87, for example, has 13 possible values that I want in the combo box, so there are 13 instances of 87 in the left column of this query).
Here's the problem. When I set the row source for the Combo Box to the the query [Bonus ID to valueList], it does not restrict the list to just the current ID. Instead, it lists the possible values for ALL Bonus ID's.
I currently have this Combo Box set up like this:
Name: comboIndMult
Source: indMult (field on Table:Bonus...so what the user selects from this combo will be stored in this field)
RowSource: SQL statement with (column 1)Table:Bonus:bonusID joined to query [Bonus ID to valueList] via bonusID and displaying field (column 2) [valueList].
Column Count: 2
Column Widths: 0";2"
Bound Column: 1
So shouldnt this Combo Box be restricted to ONLY the values with the current Bonus ID?!
I hope this description makes sense. Thanks for any help! I've been tearing my hair out for the last two days over this.
Thanks!
-DK