AutoExpand stops working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 
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
 
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?
 
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
 
Back
Top