All, using access 2016. I have a database in which I have a form with a combobox to select from the main tables primary id. additional the form has 3 subforms. The user can open a report based on the combobox Id. The users want to be able to build their own report so they want to also select an ID from the subforms also to further drill down their selection. Can anyone suggest code to achieve this task? My combobox has the code to search in the afterupdate event.
I would also have to create comboboxes to filter the each subform but not sure how to write the code for multiple selections..hopefully I made it clear what I need. Some assistance pls..thanks