filtering a listbox

[Rasberry]

I can't figure out what I am doing wrong. I have a listbox created, but I want to specify only certain records in that listbox based on a field. I tried applyfilter, but I guess I am applying it wrong.

 

[Montez659]

If the listbox is based on a query, then you would filter the query. If it is a value list, then I know of know way to filter it except to limit the items that you are adding.

 

[Rasberry]

The listbox is based on a table. I had a macro that opened the table, then applied the filter and it worked, but I can't get it to change the listbox.

 

[jackd]

An approach:
Use a query as the Rowsource of the listbox, adjust the query as necessary (your filter criteria) then requery the listbox.

 

[Montez659]

Ok, first, you probably want to create a query and filter waht you need through the query as opposed to running it directly off of the table.

And not knowing your other code, a little Me.Repaint in VBA after the query runs never hurts.