Limiting results in Combo Boxes

  • Thread starter Thread starter John McGlade
  • Start date Start date
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
 
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)
 
Back
Top