typing directly into a combo

[lawsonium]

What I would like to do is be able to type directly nito a combo box but have the combo box expand and locate the record you are looking for.

e.g.
If you have a series of records with ID's 1 to 10,000 and you type in 985 for the record ID you are searching for, when you hit the 9 it locates the first record beginning with 9 then as you hit the 8 the combo box locates the first record with ID beginning with 98 and then when you finally hit the 5 it brings you to record 985.
This obviously assumes the combo box Row Source is Sorted by the ID number.

Thanks in advance.

Matt.

 

[llkhoutx]

You should lookup/search on another field, not the index.

 

[Wiz47]

What I would like to do is be able to type directly nito a combo box but have the combo box expand and locate the record you are looking for.

e.g.
If you have a series of records with ID's 1 to 10,000 and you type in 985 for the record ID you are searching for, when you hit the 9 it locates the first record beginning with 9 then as you hit the 8 the combo box locates the first record with ID beginning with 98 and then when you finally hit the 5 it brings you to record 985.
This obviously assumes the combo box Row Source is Sorted by the ID number.

Thanks in advance.

Matt.

If the combobox is set to order the "record numbers" ascending (and that's what is showing in the combo) - then when you open (click on the down arrow) of the combobox and enter a number in the blank field - it should already do what you want.

If something else is in the combox (not numbers) then llkoutx is absolutely correct, you should do your search on another more descriptive field.

 

[lawsonium]

Hi, Yeah, I got it.

What I actually needed to do was gt it to automatically drop down and start showing what I was searching on. I have got that now.

Thanks.

 

[Wiz47]

Hi, Yeah, I got it.

What I actually needed to do was gt it to automatically drop down and start showing what I was searching on. I have got that now.

Thanks.

Good, glad you got that working.