Limiting results in Combo Boxes

[John McGlade]

I am using a combo box to display the results of a query
for which there is only one value returned. I am trying to
have the information added automatically without having to
select the drop down box control. Does anyone have an idea
as to how this can be done?

Thanks,

John

 

[Pavel Romashkin]

Is it the Default property you are looking for?

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&[email protected]

and the thread.
Pavel

 

[Van T. Dinh]

You can use the statement:

Me.Combo1.Value = Me.Combo1.Column(0,0)

assuming the BoundColumn of your ComboBox is the first Column.

(Note: Column index is zero-based)