AutoExpand stops working

A

AliKwok

Hi

I can't work out why this happens - works OK a few times, then no more.
Control is an unbound combo box, 'RowSource' setting is a simple SQL
statement:

SELECT LOCAL_Customers.CustomerID, LOCAL_Customers.Name
FROM LOCAL_Customers
WHERE (((LOCAL_Customers.IsInactive)<>"Y"))
ORDER BY LOCAL_Customers.Name;

Dropdown still works fine, but no autoexpand until I scrap the control and
redo it.

Thanks in advance for any clues.

AliKwok
 
A

Allen Browne

Try adding DISTINCT to the SQL, i.e.:
SELECT DISTINCT LOC...

There was a bug related to that in some circumstances.

Presumably:
- The combo's AutoExpand property is Yes,
- You have suitable entries under
Tools | Options | Edit/Find | Don't display lists...
 
A

AliKwok

Thanks very much Allen

Sorry - I'd just found that same answer by the time I got yours. Works a
treat now.

By the way I lived in Perth til I was 9. Miss the heat & the dry - living as
I do now in 'Ork' land NZ. WET AZ!

Cheers

AliKwok
 
T

techwizard

I have exactly the same problem... on one form the combo box
autoexpand works for one field but not for another.

It's also intermittant, sometimes works on one particular field, then
in a later session it's given up the ghost again.

Does anyone have any ideas?
 
T

techwizard

Taking out ANSI 92 reference stopped some of the more complex SQL queries working.

Instead leave it in but ensure that you make each combo box select a SELECT DISTINCT
 
Top