Recent content by Econ2016

Thank you Minty. I will organize my priorities and chip away at it using your suggestions. If I run into further issues, I will get back to you. Greatly appreciated.

Hi Minty, Do you have an example of this that I could follow somewhere?

Thanks a lot! I will take a look at this site. At a glance it looks like it has what I'm looking for. It does. However, when I code it your way and then put multiple options with 'OR', it opens every report listed in the code :(. As mentioned earlier, my example is following a method...

@pbaldy Thanks so much for the advice. This might be premature but I've been able to rid of the Loc popup box. The code I am now using is as follows: DoCmd.OpenReport "TorontoSales", acViewPreview, , "Forms!Form1!Loc='Toronto'" '&' "Forms!Form1!Rep='Sales'" I will now try it with multiple Open...

Yes they are, pbaldy. Loc is the name of my first combo box, and Rep is the name of my second combo box, both on the same form. The user will select the location, select the type of the report, then click the generate report button and voila. The reports are named "Location""ReportType"...

Hi pbaldy. It actually is not a field in the report's record source.. strangely enough. Also, AND does not work. I get "Type Mismatch". Instead, I use & between the combo boxes, and '&' in the second part: DoCmd.OpenReport Forms!Form1!Loc & Forms!Form1!rep, acViewPreview, , "[Loc]='Toronto'"...

Update: DoCmd.OpenReport Forms!Form1!Loc & Forms!Form1!rep, acViewPreview, , "[Loc]='Toronto'" & "[Rep]='Sales'" First, when I had my report named as "Toronto Sales", I got an error that "The report name TorontoSales is either misspelled in the Property sheet or the Macro. After renaming it...

I only have a limited number of reports so managing it would not be too difficult. Is there not a way for the report name to be recognized as the selection in multiple comboboxes? Also, I don't understand creating a report with all the locations and then opening it with a filter. How does one...

Hello All, I'm an Econ master's graduate now working in the transportation economics field. I have decent coding skills in Stata and Matlab, but have to use Excel and now Access at work. Looking to polish my skills and turn to you all for help should I run into any troubles. I am also learning...

Hi All, Not sure if this is the right section to post this but I hope it is. I have a set of reports stored in Access, and I am trying to generate a specific report based on multiple combo box selections and a "run report" button on a form. For this example, Combo Box 1 = Location, and Combo...