make a combobox default to first item in list? (1 Viewer)

[telepathetic]

I have a combobox list that runs off a query. The results of the query are constantly changing, but each time the combobox gets requeried, i'd like it to default to the first item in it's list. How do i get it to do that?

 

[RpbertS]

have you tried putting:
[cboname].[ItemData](0)
in the default value property of the combo box?

 

[telepathetic]

yes-- it did work!! thanks!
that leads me to a tougher question. I have a category and subcategory combobox. I'd like the default for the category to be the first item in its list-- which i can now do. Now how do i get the subcategory to default to the first item in its list dependent on what the category combo has chosen as its default.

The defaults for the controls seem to be populated independent of dependent query info. The query for the subcategory combo is dependent on the value in the category combo, but on the initial load when the defaults are populated this relationship doesn't seem to matter. It seems as if the subcategory query occurs before the categorycombo has its default value and the subcategory combo therefore has errant values.
anyone got a clue about this??