I have very limited knowledge of access and am trying to create a report that will use a combo box filter. The Db has one table where people will input data based on a form. I have created some querys and reports, but having people type in the items...
I have very limited knowledge of access and am trying to create a report that will use a combo box filter. The Db has one table where people will input data based on a form. I have created some querys and reports, but having people type in the items to parameter query can cause problems if they are not spelled correctly.
I have created a combo box filter for a query and have gotten it to run ok based on information I have found, but you then would have to run the report based on the query. I would like to simplify it as much as possible so the results are correct.
I created a form with two combo boxes that are linked to the list tables. I am having problems figuring out the code so that when I hit the ok button, it will filter the report by the choices in the combo boxes. Is there specific code that I can put into the "ok" button to do this?