Having Combo boxes populate without clicking on them

[Guest]

I have a combo box that is populated by a query that limits the values to
one, and would like to have the Combo box populate without needing to click
on the drop down box to select the one possible entry. I tried using just
using a list box with no drop down, but it would not populate the table
correctly that is bound to the combo box.

Any ideas on how to have the combo box automatically load the data from the
query without selecting the dropdown?

Thanks

 

[Guest]

hi,
I think you have confused yourself. if you only have one
possible entry.....why are you using a combo box? combo
boxes are for multiple possible entries. text boxes are
for single lone entries. and a combo box query will
not "populate" itself. the combo box was developed to
allow users to "pick from a list". in your case, you don't
have a list.
to populate the text box
1. use dloolup using your combo box's query criteria
2. Use the combo box's query to create a recordset then
have the one single lone recordset object = me.txtbox1