ComboBox Autocomplete

[AdrianKitchen]

Hello,



Using Access 2003, I have a combo box that calls back data to the Row Source using the following:

SELECT Grp.GrpName FROM Grp ORDER BY Grp.GrpName;

As this is a very long list I would like to know if there is any way to show the details as the person using this types in the name (e.g. they type in an 'E' and it moves straight to the 'E's)

Any help would be greatly appreciated.

Many thanks,

Adrian

[RuralGuy]

Perhasps this link will work for you.

[AdrianKitchen]

Thanks, I couldn't get it to work, but it gave me another direction to go in and I have come up with a workaround adding another list to filter down by first letter.

Cheers,

Adrian

[RuralGuy]

Glad you got it sorted.