Hello,
This might be a little advanced, I'm not really sure how to make this happen. So basically the plan is that I click a button, it opens up a small form, I click a name in the dropdown and it will take that "ID" and automatically apply it to a report that I want it to open after I hit a "Go" button.
In this case I want to make a report that shows all Employees dates of absence for whichever employee I select from the dropdown. I "could" do this and skip the form, and have the dropdown on the report, issue being that the dropdown doesn't function on the report so it wont work. I need to make some sort of VBA/Macro that after I click does an ApplyFilter like to command to the report not the form itself as that is no use. I will include a screenshot of the forms dropdown to show its simplicity.
This may not be the most efficient way but once I solve the issue of applying the appropriate filter, I can then work on the flow and design of the report.
Thanks!