Search List Box

[Jeefgeorge]

I have a ListBox with several columns: [Std No], [Description], [Unit],
[Cost], [Updated]. Where the [Std No] column is bound and hidden. When a
line item is selected in the List box, the user inputs a quantity and a cost
estimate is generated. Currently I have a ComboBox which filters the ListBox
by category. I would like the user to be able to search by [Description],
where if 8" is entered, the ListBox shows all line items in the selected
category with 8" anywhere in the field.

Any help is appreciated.

 

[pietlinden]

I have a ListBox with several columns: [Std No], [Description], [Unit],
[Cost], [Updated].  Where the [Std No] column is bound and hidden.  When a
line item is selected in the List box, the user inputs a quantity and a cost
estimate is generated.  Currently I have a ComboBox which filters the ListBox
by category.  I would like the user to be able to search by [Description],
where if 8" is entered, the ListBox shows all line items in the selected
category with 8" anywhere in the field.  

Any help is appreciated.

so requery the listbox in the AfterUpdate event of the combobox.

 

[Jeefgeorge]

The list box works correctly with the combo box, but the resulting items
shown in the list box cannot be searched by the description, some of these
sections have several hundred line items, so scrolling thru would be
cumbersome

example:
User Selects "General" in the ComboBox
The list box shows all the line items in the General Category i.e.
Mobilization, Incidental, Traffic Control, Construction Staking, Flagging...

if the user wants to select "Construction Staking" i would like the ability
to search the list box - i.e. if "staking" is input into the search
"Construction Staking" is returned

I have a ListBox with several columns: [Std No], [Description], [Unit],
[Cost], [Updated]. Where the [Std No] column is bound and hidden. When a
line item is selected in the List box, the user inputs a quantity and a cost
estimate is generated. Currently I have a ComboBox which filters the ListBox
by category. I would like the user to be able to search by [Description],
where if 8" is entered, the ListBox shows all line items in the selected
category with 8" anywhere in the field.

Any help is appreciated.

so requery the listbox in the AfterUpdate event of the combobox.