opening reports 1

[villsthearcher]

Hello,

I am able to open a Form, enter a parameter and then Run the Report.

But if I again enter a new parameter value, when the Report for the previous parameter value is OPEN, it doenot show a Report for the new value.

But when I CLOSE the report for the previous parameter value, and run again, it opens a report for the new parameter value .

Can anyone tell me, how do I refresh the value in the text box I use to enter the parameter value, instead of closing the report and then running it again?



Thanks,
villsthearcher

 

[RoyVidar]

I think I'd tell the users to close the report first;-)

You could of course do something like this, in the "refresh/open" button thingie

[tt]if currentproject.allreports("NameOfYourReport").isloaded then
docmd.close acreport, "NameOfYourReport"
end if
docmd.openreport "NameOfYourReport", acviewpreview,,<your criterion>,...[/tt]

which I think might work

Roy-Vidar

 

[villsthearcher]

olaaaaaaaaaah!!!!!

works like magic, Roy.

You are a life saver

Thanks,
villsthearcher