Combo Box Auto Expand

[jlgray0127]

Hi again!
I have a form, with a combo box that looks at values on another table.
Values to choose from are below:
100-01-a
100-01-b
100-01-c
100-01-d
100-02-a
100-02-b

and etc...

(Just an FYI... I set the table up to keep the dashes in the record, for future reporting needs. There's already thousands of records I've imported into the database and added after.)

I used an input mask, because I do not want the user to have to enter the dashes when typing in the value to select what they are looking for. There are over 400 records to choose from. This works great, with the exception, when the user types a 1 when they get to the combo box, it autofills with first record, and the cursor moves to the end of the record, not allowing them to continue typing.
I turned off the auto expand, and it does just want I want, other than it does not recognize the record on the table once they are done typing.

The way I'm wanting this to work, is for the user to just type in the location, with no dashes, and for the database to only accept the record if it exsists on the table. I thought the combo box was a great solution, because you can expand the list and see what your options are, if needed. However, if this isn't working properly it's just creating a lot of backspacing and typing. Is there a more simple way to accomplish this?

Thanks in advance!

[Rawb]

Disabling Auto Expand should be exactly what you need so I'm not sure why it's not working for you. And even if it was using Auto Expand, the Combo Box wouldn't move the cursor to the end of the Control/Record - you should be able to just keep typing and be good.

It almost sounds like there's some VBA code on the Key Down, Key Press, or Key Up Events that's doing it.

Can you upload a copy of the database for us to look at?

[jlgray0127]

Unfortunately, I'm not sure how I can send it. It's a very large data base with a front end and back end.
However, there is nothing in the key events. I'm not sure what the deal is with it.
I type a 1, and it automatically fills the field with the first record, and you have to back space or delete the record, then it will let you type the entire value without having to type the dashes.
I'm just going to take the input mask out and force the users to type the dashes. Very frustrated and spent hours researching, to figure this out, to no avail.
Alot of wasted effort just to stop someone from having to type a dash.
Thank you for offering your support!