How do I stop combo box from going to end of first found record?
Posted on 2013-06-25
Using MS Access 2007 I have created a bound combo box that has a query as its RowSource. When I type in a number I want it to display the entries in the rowsource and let me progressively enter the numbers and see the matchin results. For some reason as soon as it finds a record that commences with the first number(s) I enter it automatically selects that record and jumps to the end of the field. How do I stop this and force it to display a list.
E.g. The RowSource has records that look like the following. As soon as I enter 3 in the combo box it automatically selects the first record that commences with a 3 and fills the box. I want it to simply display the entries starting with 3 and let me keep typing: