MS Access 2013 - Filter values in a list box, based on value in a Text box

ms-access ms-access-2013
user2308227 picture user2308227 · Apr 23, 2014 · Viewed 12.4k times · Source

I have made a form with a Listbox displaying a lot of names and addressees based on a query. How can I filter the names in the form, based on a Text box in the same form?

(Not all the names are relevant for every record)

Answer

SEM_jmc picture SEM_jmc · Apr 23, 2014

The listbox has a RowSource, so you can modify it on the fly: 

Me!Listbox.RowSource = "SELECT .... FROM .... WHERE ..."
Me!Listbox.Requery

to modify the SQL with the value in the Textbox, use the Textbox AfterUpdate event

Related questions

Access 2013 - Cannot open a database created with a previous version of your application

I have an Access database created more than 10 yrs back. I have very important data in it & I think it can be opened in Access 2007 or earlier version. Currently I have Access 2013 in my desktop and opening the file …

Read More
Combobox null in if statement

I am trying to code an if statement where if a certain combobox is null, then it runs a certain part of code if it has data in it then it runs another. I wrote up this: Private Sub ProjectAddSetDateAutoBtn_…

Read More
How to determine if a table contains a value in SQL?

I feel like I'm missing something very obvious here, but it seems that the only way to go about doing this is to get the value, and then see if it returns a null (empty) value, which I would rather …

Read More