I am working in Access 2016 and I have a from that the user can select the training type the want to run the report on. All trainings has an option value of 1, Bloodborne has an option value of 2 and so on. I want to take the value of my form and pass it into a query so it will display all employees that took that training.
My form is View February Training and contains a option group within a frame that is called FrameAllorCurrent. My query contains the training field which I am able to filter with the following Like "68" Were 68 is the training ID from the training table.
I know I have to do something in the training field of the query along the lines of [forms]![View February Training].[FrameAllOrCurrent].Value = 2 but how do I make it so when it equals 2 it makes the training field "68" and returns all my bloodborne trainings?