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


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
 
Ad

Advertisements

D

Dirk Goldgar

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?


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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top