Add dropdown box in report?

[rgao]

Hi, there
Does someone know how to make Access report interactive,for example put a dropdown box in report,choose different item,the report can disply differnet information.As far as i know report is not interactive, form is interactive,but form is not good at presentation(eg.group data).if you guys know some clues, Pls let me know. Thanks in advance.

Best regard

Rgao

 

[Carina1628]

Don't know if this is what you want, but when I need to print the same report with different groupings, I use a form with a combo box to select the criteria before the report generates. You would have to close the report in order to select new criteria though, so it isn't really interactive. If this sounds like what you want to do, you can find instructions on setup by entering "report criteria form" in Access Help. Choose the "Use a form to enter report criteria" subject and it will give you the instructions to create the form. You will have to create some macros too, but it is relatively easy. Hope this helps.

 

[rgao]

Hi,Carina1628
Thanks for your message,I searched in internet and found It's impossible to make report interactive.right now I'm trying to work on access page ,it may help (but i never use it).
Thanks again

Rgao