Combo Box in Subform Doesn't Accept First Character on a New Recor

  • Thread starter Thread starter CevinMoses
  • Start date Start date
C

CevinMoses

I had a continuous subform which allows me to select a part number from a
combo box to add it to the order. The list of part numbers is quite long
(150+), so it's benefitial to be able to start typing and have the list start
working its way down to possible matches.

My problem is that when I click on the combo box, either the field or the
drop-down arrow, it does not register the first character of the part number.
The first character I press creates the record, which causes the blank "new
record" to pop up underneath, and then the second character and beyond show
up in the control.

For example, if the part number I wanted were 12345, and I clicked on the
combo box and started typing, it would create a new record and go to part
number 2345.

This seems riddiculous, but I'm wracking my brain here. What am I missing?

-Cevin
 
CevinMoses said:
I had a continuous subform which allows me to select a part number from a
combo box to add it to the order. The list of part numbers is quite long
(150+), so it's benefitial to be able to start typing and have the list
start
working its way down to possible matches.

My problem is that when I click on the combo box, either the field or the
drop-down arrow, it does not register the first character of the part
number.
The first character I press creates the record, which causes the blank
"new
record" to pop up underneath, and then the second character and beyond
show
up in the control.

For example, if the part number I wanted were 12345, and I clicked on the
combo box and started typing, it would create a new record and go to part
number 2345.

This seems riddiculous, but I'm wracking my brain here. What am I
missing?
Click to expand...


Is there code or a macro in any of the combo box's events? Does this happen
only when you first enter the subform from the main form, or does it happen
if you try to enter multiple records in the subform, one after another?
 
Back
Top