making data items invisible in combobox

[50ld13r]

hi

not sure if this is possible but i only want certain options to be made visible in a combobox when the user selects the relevant options. Therefore i want to be able to make certain items in my combobox invisible, while some are visible and when the user sets the other values the invisible options become visible

Thanks

 

[Studentos]

What is the row source type for your combo?
If it's value list, you can fill your combo programmatically with any data you need ( Combo1.AddItem "abcd" )
If it is a Table/Query - update RowSource property with query you need.

 

[ejstefl]

Try doing a search for "Cascading Combo Boxes" or check out this link: http://www.fontstuff.com/access/acctut10.htm

 

[50ld13r]

thanks for your replys. My problem is slightly to do with cascade combos i think. i have a number of yes/no selections for different options. I then have 1 main combo list with a row source from a table. In my main combo i have 8 options but initially for example i only want the first 4 showing. If one of the yes options is selected i want 1 - 6 showing. If another yes is selected i want options 2-8 showing and if on another yes selection i want option 6-8 showing.(the yes selections are all different combo boxs intergrated into the system - indicating completion of different events)- The 3 yes/no combos dictate the main combo display - i assume i have queries on all the permutations i have described?

 

[ejstefl]

Sounds like you would just need to update the rowsource for your combo box in the after update event of each checkbox. You will need a new SQL statement for each of the permutations you described.