Can only make certain combo box selections
The row source type for my bound control is from a table. The rowsource is a query based on the table. Essentially combo shows a retailer and retailer store number as well as the retailer name. What I’m finding though is that whenever I make a selection I can only select certain combo values.
For example our retailer and store number is displayed like this 33333-00001, thus retailer 33333 can have many stores 00001,00002 etc.
I’m finding though that I can only select the 00001 store number from my combo list from all the retailers listed and not any other. I’d appreciate any advice. Please advise.
The row source type for my bound control is from a table. The rowsource is a query based on the table. Essentially combo shows a retailer and retailer store number as well as the retailer name. What I’m finding though is that whenever I make a selection I can only select certain combo values.
For example our retailer and store number is displayed like this 33333-00001, thus retailer 33333 can have many stores 00001,00002 etc.
I’m finding though that I can only select the 00001 store number from my combo list from all the retailers listed and not any other. I’d appreciate any advice. Please advise.
