Using Textbox to search for an item from a ListBox

[tara99]

I have a list box called CCList which displays a field form table based on a query

SELECT CC.table1 FROM table1 ORDER BY CC.table1;

Each CC consists of 5charecter starting with a letter the rest is number (e.g.: A0214. D2145,Y0568 and etc...)

The list box is huge so the user needs to scroll down to find what they looking for.
To make it easier for the user I have created a textbox to perform a search.
I want the user to enter either the first letter or the item number in the text box and based on the user input the CCList should jump to that (input) item.

I was just wondering how I can do this.

[MMcCarthy]

Similar answer to previous question Tara.

Set the list box row source to the following:

SELECT CC.table1 FROM table1 
WHERE CC.table1 Like [Forms]![FormName]![textboxName]*
ORDER BY CC.table1;

Put the Me.listboxName. Requery statement either in the after update event of the textbox or behind a command button.

Mary

[missinglinq]

Wouldn't it be easier for the user if a combobox was used with Auto Expand set to YES?

[NeoPa]

Wouldn't it be easier for the user if a combobox was used with Auto Expand set to YES?

For the first part Yes.
For the second that wouldn't help - good point to bring up though :).

[tara99]

Similar answer to previous question Tara.

Set the list box row source to the following:

SELECT CC.table1 FROM table1 
WHERE CC.table1 Like [Forms]![FormName]![textboxName]*
ORDER BY CC.table1;

Put the Me.listboxName. Requery statement either in the after update event of the textbox or behind a command button.

Mary

Mary
I put

SELECT CC.table1 FROM table1 
WHERE CC.table1 Like [Forms]![FormName]![textboxName]*
ORDER BY CC.table1;

Behind the row source of my list box, it complains about syntax error which is the [textboxName]* when I delete the sign * than it doesn't display any thing the list.
It just wait for the user to enter something in the textbox if it exist than you will see it on the List box.
/???

[MMcCarthy]

Mary
I put

SELECT CC.table1 FROM table1 
WHERE CC.table1 Like [Forms]![FormName]![textboxName]*
ORDER BY CC.table1;

Behind the row source of my list box, it complains about syntax error which is the [textboxName]* when I delete the sign * than it doesn't display any thing the list.
It just wait for the user to enter something in the textbox if it exist than you will see it on the List box.
/???

Try this ...

SELECT CC.table1 FROM table1 
WHERE CC.table1 Like [Forms]![FormName]![textboxName] & "*"
ORDER BY CC.table1;

[tara99]

Try this ...

SELECT CC.table1 FROM table1 
WHERE CC.table1 Like [Forms]![FormName]![textboxName] & "*"
ORDER BY CC.table1;

Thanks Mary

It is fine now

[MMcCarthy]

Thanks Mary

It is fine now

That's great Tara

Mary