Combo box default value

  • Thread starter Thread starter hotplate
  • Start date Start date
H

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));
 
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
 
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.
 
Back
Top