Lookup inventory number

[Polarbear]

I have an inventory supply database table with a subform for invoicing and
purchasing. The inventory items are numbered such as 72041, 50002, 22001,
etc. When I enter the first number, say 2, in the drop down box I would like
the items in the 2xxxx category to be listed in a dropdown box so that I can
choose the number for faster lookup instead of entering the whole number. Is
there any way of doing this?

Thanks.

 

[Klatuu]

The Combo Box control (dropdown) has an Auto Expand property. make sure it
is set to Yes. That is what the property does.

 

[John W. Vinson]

I have an inventory supply database table with a subform for invoicing and
purchasing. The inventory items are numbered such as 72041, 50002, 22001,
etc. When I enter the first number, say 2, in the drop down box I would like
the items in the 2xxxx category to be listed in a dropdown box so that I can
choose the number for faster lookup instead of entering the whole number. Is
there any way of doing this?

Thanks.

If you leave the default AutoComplete property of a combo box on, a simple
combo box on a form will do just as you describe: type 2 and it will jump to
the first record starting with 2, then type 3 and it will jump to the first
record starting with 23, and so on. You can either select the record it jumped
to, or if the desired record is a bit further down in the list, arrow or mouse
down to it and press <enter> to select it.

I hope you're working on a Form rather than in the table datasheet directly...
tables are for data storage, Forms for data interaction.

 

[Polarbear]

I checked this and it was set to Yes but it still doesn't work.

 

[John W. Vinson]

I checked this and it was set to Yes but it still doesn't work.

"Doesn't work" in what way?

Please post the following info about the combo box:

RowSource (post the SQL view if it's a query, explain if it's not)
Control Source
Bound Column
ColumnWidths

The autoexpand applies to the first nonzero width column, which probably won't
be the bound column; and it only works well if the combo is sorted by that
column.