Have filter on list box's record source?

[lorirobn]

Hi,

I have a list box on a form. I needed to filter records displayed on the list box depending on a separate combo box selection. I coded the SQL and filter in the VBA module of the form, and it works fine. As I become more familiar with Access and VBA, I am wondering if there was a simpler way to do this, using a query as the list box's record source (which I can do easily), and adding a dynamic filter onto that.

Is there a way to add a filter onto the recordsource query of a list box, as you can do with a form's filter? It seems so complicated to have all that code within VBA (I am concerned about upkeep by users).

Thanks in advance...

 

[MajP]

Something like this?
faq702-4289

 

[lorirobn]

Hi MajP,

I think I wasn't clear about my question. My question is, is there a way to add a filter to the list box's query. I shouldn't have even mentioned the combo box at all.

My list box has a query as its record source. I may or may not want to filter records. I would dynamically like to add a filter, if so desired. I know this is possible with the form's record source (me.filter); it it also possible with a list box's record source?

Thanks...

 

[Knicks]

I believe "filters" are inherant to FORMS. Seeing how your list box's record source is a query/sql, probably the best you could do is limit the data through a parameter or sort it.

 

[TheAceMan1]

lorirobn . . .

You can use an [blue]base SQL statement[/blue] to which you [blue]add dynamic criteria[/blue], updating the RowSource with the new SQL . . .

Your thoughts?

See Ya! . . . . . .

 

[lorirobn]

thanks... I guess I'll stick with what I have, which is exactly what Aceman suggests - a base SQL statement to which I dynamically add criteria.
Thanks...now I know I can't do a filter with my list box.