Combo box default value

[hotplate]

I have a combo box which gets its values from a query. Each combo box
previous to it narrows down the choices till finally the last combo box
only has one choice. How can I make it so that the one choice
determined by the query is the default value? Is there a better way of
doing the last choice since it is always going to have one value
(something other than a combo box)?

Here is the query that determines the type if it helps:
SELECT tblConcerns.Type, tblConcerns.Dept, tblConcerns.Category,
tblConcerns.Component, tblConcerns.Concern FROM tblConcerns WHERE
(((tblConcerns.Dept)=forms!frmDate!Dept) And
((tblConcerns.Category)=forms!frmDaily!Cat) And
((tblConcerns.Component)=forms!frmDaily!Comp) And
((tblConcerns.Concern)=forms!frmDaily!Con));

 

[jahoobob via AccessMonster.com]

Let's assume that you're talking about Concerns (the field) and that the
textbox (don't need a combo) in which you want to display it is named
Conerned. In the Afterupdate property of the combo box (assume it is named
Combo4) that narrows Concerns to one choice place this code:
Me!Concerned=Me!Combo4!Column(4)
This assumes that the query you showed is used in Combo4

 

[hotplate]

Thank you, It took me a while to figure out I needed to change the
column number from 1 in the combo box, but it worked.