Button to filter report based off combobox selection

[pbaldy]

If the criteria are on the same line, both have to be met. On separate lines, either has to be met.

 

[peter_lantz]

Hello,

I'm trying to do a similar task. I want my combo box to be filter by a column in one of my tables in Access and the button to execute a query based on the criteria of that filter. Is this possible to do? Or is there another way I should go about this?

 

[pbaldy]

Have you tried the solutions presented in this thread? Most of us don't expose queries or tables to users, only forms and reports. Your query can refer to the combo in its criteria.

 

[peter_lantz]

Oh ok. I am very new at this, I just started a BA position 07/01 so I'm pretty green. I'll look through the thread a bit more.

 

[peter_lantz]

Have you tried the solutions presented in this thread? Most of us don't expose queries or tables to users, only forms and reports. Your query can refer to the combo in its criteria.

I watched a video that was posted and that's exactly what I wanted to do thanks!

 

[pbaldy]

No problem, and welcome to the site by the way!

 

[peter_lantz]

Thanks! I'm really excited to get my feet wet with more Access DB.