Limiting results in Combo Boxes

J

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
 
V

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)
 
Top