Combo Box Selections

[KsFireworksGal]

I have two forms the first form works great it consist of

Box Number - user enters box number which corresponds to a Assigned Box List
Description - user types in product name this is a combo box that will bring
up a name based on user entry and user can select from down arrow
Item Number - auto fills based on afterupdate SQL code on the Descriptionfield
Quanity - user enters based on information they have
Packing - user enters from combo box each, pack, box, brick

As I said this works well, but I want am trying to create a flip of this
form so that the user can enter with the Item Number and the Description auto
fills. So for the auto fill works. My problem is that the Item number
doesn't let me start typing and bring up a number. I have to scroll through
all the items to find the correct one - this defeats the purpose of what I am
trying to. What am I missing?

I have checked my bound columns and they are correct.

Any help is appreciated.

Lynette

 

[Jeff Boyce]

As I recall, there's something like an "AutoComplete" property for
comboboxes ... is your combobox's set to Yes?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KsFireworksGal]

I did not find an AutoComplete in the properties, I have the Allow
AutoCorrect set to yes. I think it has to do with the numbers or the bound
column.

 

[Jeff Boyce]

Sorry, my bad... the correct term is "Auto Expand"

Regards

Jeff Boyce
Microsoft Office/Access MVP