M
Mark
I have a form that contains a combo box. When the combo box gets the focus I set the row source property to a SQL statement that filters the data shown in the combo box. My problems is that in Access XP you cannot type anything into the field you can only click on the arrow and select from the drop-down. When the form is run in Access 2000 you can enter in data and the autoexpand works. Normally this would not be a problem, but since the combo box contains a thousand or so entries it takes the users a long time to scroll and find the value they need. The form is in an Access project. I read in the knowledge base about a problem with autoexpand in an Access mdb, it suggested using DISTINCT in the SQL statement. I tried this but it made no difference.