Conbo box - one row - how to select

[Webskater]

Hi

I have a combo box which is populated as the result of a user doing a search. If the search only produces one record the combo box only has one row..

How can I make the combo box select the one row?

At the moment the combo box still shows empty and you have to drop it down and there is only one option to select.

Thanks for any help.

I have ....

If Me![CompanyList].ListCount = 1 Then

... But don't know how to make the Combo Box select its only row.

 

[Oldsoftboss]

If Me![CompanyList].ListCount = 1 Then
Me![CompanyList].Selected(0) = True
End If

 

[Webskater]

If Me![CompanyList].ListCount = 1 Then
Me![CompanyList].Selected(0) = True
End If

Hi, thanks for your answer.

I tried it and got a message that said something like 'Property or method not available'

There is definitely only one row in the combo box.

Cheers