Data Entry shortlisting selections

[ebo2006]

I have a very large table to do a dropdown list. How can you shortlist the selection options as it is being spelled out. Example, as I enter ORT for my name selection, the options will show only those starting with ORT. And as more letters are entered, the options are shortlisted further. I have seen this in some sites, but I don't know if this is possible in MS Access.

[missinglinq]

It's normally default behavior when setting up a combobox, but go to the box's Properties - Data and set AutoExpand to Yes!

Welcome to TheScripts!

Linq ;0)>

[ebo2006]

Thanks. I'll try that.

It's normally default behavior when setting up a combobox, but go to the box's Properties - Data and set AutoExpand to Yes!

Welcome to TheScripts!

Linq ;0)>

[ebo2006]

I tried it and it works.

However, the WHERE clause of the SELECT statement in the Row Source Property of the combo box works only every time I start the form. It does not change the list options when I select another ID from another combo box in the form. Why is this so?

Here is my select statement

SELECT [Courses].[tech], [Courses].[corp] FROM Courses WHERE [Courses].[corp]=form.ID ORDER BY [Courses].[tech]; 

It's normally default behavior when setting up a combobox, but go to the box's Properties - Data and set AutoExpand to Yes!

Welcome to TheScripts!

Linq ;0)>