Filtering a combo box with a text box?

[laccess]

Hi All,

Ok so I posted previously about trying to search in a multi value combo box.

It doesn't sound possible nor do people like the sound the multi value box.

What I'm trying to do now instead is add a text box, next to the combo box, that I can type in which will reduce the combo box to only include records that have the same word In the text box.

I've tried creating the text box and putting [Material].refresh in the txt box afterupdate event.

And I've also tried putting LIKE [FormXYZ] [Txtbox22] in the query for the combo box using the build event?

I get both an error regarding the refresh command and a blank combo box?

Any ideas please?

 

[sneuberg]

Try

Like Forms![FormXYZ]![Txtbox22] & "*"

as shown here.



Also I if you haven't already, save the row source query of the combo box. Then you can test that part independently of the combo box by just double clicking on the query with the form open and something in the textbox.