I'm using a list box for data entry on a form. It's used to enter the product serial number and the source is a table of all valid serial numbers. Its a long list and its also numeric.
I want the user to be able to type in the number and as he's doing that, the list box hones in on the number as each digit is entered.
For example, if the number to enter is 752, when the user types 7, the list box goes to the first of the existing 700's. When the user types 5, the list box goes to the first of the 750's. And when the user types 2, the list box displays 752.
What actually happens is when the 7 is typed it hones in on the 700's but when the 5 is typed, it now goes to the 500's.
I noticed when writing event procedures and I type something like "DoCmd." a list box pops up & behaves the way I want mine to. So it must be possible ...
Any experience with this ?
I want the user to be able to type in the number and as he's doing that, the list box hones in on the number as each digit is entered.
For example, if the number to enter is 752, when the user types 7, the list box goes to the first of the existing 700's. When the user types 5, the list box goes to the first of the 750's. And when the user types 2, the list box displays 752.
What actually happens is when the 7 is typed it hones in on the 700's but when the 5 is typed, it now goes to the 500's.
I noticed when writing event procedures and I type something like "DoCmd." a list box pops up & behaves the way I want mine to. So it must be possible ...
Any experience with this ?
