Move to specific row in a combo box

[mib1019]

I have a combo box on a form

SELECT [qryTTT Media].Company_ID, [qryTTT Media].CompanyName, [qryTTT Media].Market
FROM [qryTTT Media]


WHERE ((([qryTTT Media].[Bill_ID].[Value])=8))
ORDER BY [qryTTT Media].Market, [qryTTT Media].CompanyName;

The box displays CompanyName and [qryTTTMedia].Market.

I'd like the box to zoom to the first item that is not null in the Market column. I want to keep the Market column as the first sort, but want to get to the first place in the list that actually has a Market in it.

Any ideas?
MIB1019

[June7]

Why would column have null (actually, empty string)? Why would there not be a Market?

Unusual requirement. I can think of two options.

1. loop through the combobox items list until encounter first one with Market

2. open a recordset filtered to the one record that matches criteria and set value of combobox with that record ID

Exactly when do you want this action to take place - when combobox gets focus?

If you want to provide db for analysis, follow instructions at bottom of my post.