Combo Box works, but top line displays blank

[thedrumdoctor]

I have a combo box on a form which is based on a parameter query. When a form
opens the user is asked to type in the short name of a product. The query
then brings up a cocatenated list of items that match the parameter query.
However, the top line displays as blank. When I click on the drop-down arrow,
all the correct results are displayed. It would be nice if the form would
display the combo box with the first result in the list rather than having to
click on the arrow to see it. Any ideas why this is doing this?

 

[KARL DEWEY]

Check to see if a record is null.

 

[Linq Adams via AccessMonster.com]

A "dropdown box" (combobox) that is unbound normally displays a blank line,
that way the user can start to type and take advantage of the AutoExpand
feature.

To make it display the first item, after it loads, use

Me.ComboBoxName = Me.ComboBoxName.ItemData(0)

 

[thedrumdoctor]

Is that an 'On Enter' Event?

Thanks

 

[thedrumdoctor]

Just tried it as an event 'on got focus' and this works. Thanks!