Lookup inventory number

  • Thread starter Thread starter Polarbear
  • Start date Start date
P

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.
 
The Combo Box control (dropdown) has an Auto Expand property. make sure it
is set to Yes. That is what the property does.
 
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.
Click to expand...

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.
 
I checked this and it was set to Yes but it still doesn't work.
Click to expand...

"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.
 
Back
Top