Opening report based on the selection from combobox (1 Viewer)

Hi,

I'm new to MS access, and I would like to do an experiment on how I can filter a report based on the selection from my combo box. I've watched so many tutorials but it seems like I'm having a hard time to follow it. I did even follow one tutorial from youtube and did exactly what the video says but still, it didn't work for me. It's been a week now and still, I couldn't find the right solution to complete my experiment. I hope you good people out there can help me to get this thing done.

Note: I'm using MS ACCESS 2013 and 2016, I also attached the MS ACCESS file which I'm currently experimenting.

Welcome to AWF.
There are many examples of this on this site.
For example see a more advanced version involving multiple grouping and filtering https://www.access-programmers.co.uk/forums/showthread.php?t=302189
There is also a list of similar threads at the bottom of this page

Combobox shows Gender but value of combobox is ID because the combobox RowSource is multi-column and ID is BoundColumn. The query is trying to filter Gender with ID as parameter so of course there is no match. Include ID in the query and put criteria under that field. Or modify the combobox to not use ID field.

I NEVER use dynamic parameterized query. I prefer to set filter criteria with code when the report opens. I also use VBA instead of macros.

June7 said:

Combobox shows Gender but value of combobox is ID because the combobox RowSource is multi-column and ID is BoundColumn. The query is trying to filter Gender with ID as parameter so of course there is no match. Include ID in the query and put criteria under that field. Or modify the combobox to not use ID field.

I NEVER use dynamic parameterized query. I prefer to set filter criteria with code when the report opens. I also use VBA instead of macros.

Click to expand...

I'm sorry, I didn't think about the bound column. It is working now thank you very much.