I have a parameter form where the user chooses a site name. Once the name is selected and the user hits the OKAY button, the form closes and I've set up macros to run a query and a report based on the selection. The first time I go through this, all works perfectly.
Now, when I want to run a report on another site, I run my macro (which is supposed to open my parameter form), but instead it takes my original parameter entry and goes with it. The parameter form does not open and give me the option to select a different site name.
I have a menu switchboard where I created a button to open the parameter form (trying to get around my problem with the report macro not opening it). When I open the form for the first time, it works. After I run the report, if I try to select my Open Parameter Form button nothing happens. The form simply does not open. I am using DoCmd.OpenForm "FrmSiteNameParameter" in the OnClick Event of my button.
I am really stumped and have tried searching for an answer without success. I am using Access 2010 and am a novice. Please help me!
Now, when I want to run a report on another site, I run my macro (which is supposed to open my parameter form), but instead it takes my original parameter entry and goes with it. The parameter form does not open and give me the option to select a different site name.
I have a menu switchboard where I created a button to open the parameter form (trying to get around my problem with the report macro not opening it). When I open the form for the first time, it works. After I run the report, if I try to select my Open Parameter Form button nothing happens. The form simply does not open. I am using DoCmd.OpenForm "FrmSiteNameParameter" in the OnClick Event of my button.
I am really stumped and have tried searching for an answer without success. I am using Access 2010 and am a novice. Please help me!