Problem with auto expand on combo box

[cookie5]

I have a combo box on a form that has auto expand and limit to list set to yes. There are over 3,000 items in the list. If I put in w, n, s, or e it correctly displays items that begin with those letters then have a blank (i.e. W 10th St. or N 11th St) but if the item I need is Westwood lane, no matter how many letters I put in it does not display any selection. I have the field row source sql as
SELECT DISTINCTROW tblonst.[onst num], tblonst.[onst loc]
FROM tblonst
ORDER BY tblonst.[onst loc];

What am I doing wrong or not doing?

Thanks

 

[missinglinq]

SELECT DISTINCTROW tblonst.[onst num], tblonst.[onst loc]
FROM tblonst
ORDER BY tblonst.[onst loc];

Where did you get this SQL from? The SQL the combobox wizard would produce for this purpose would be something like:

SELECT [tblonst].[onst num], [tblonst].[onst loc] 
FROM tblonst;

SQL isn't my long suit, by any means, but as I understand it, the purpose of DistinctRow is to return only one of several possible rows, which I think is exactly what it's doing.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[cookie5]

Thanks Missionglinq but the result is the same. Any other ideas?

 

[missinglinq]

Not a clue; itworks as it should for me.

Good Luck!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!