Query choice and print a report (1 Viewer)

[access2010]

Up until now we have been making separate reports, each report with their own query to group ONE field from for example the field = TRADE = so that we can print a report of that one choice using Access 2003.

Can I please receive a way of choosing an item from our Combo Box such as = Watch or another choice “ so this will than group all the = Watch = records and then print our report, with our choice from the Combo Box?

This will save us from making SO many individual reports

Your suggestions will be appreciated.

Thank you.
Nicole

 

[Uncle Gizmo]

This isn't the answer to your question, it's a different way of generating multiple reports which I thought you might find of interest..

Generate Multiple Reports - Nifty Access

Generate Multiple Reports This blog came about because of an answer I gave to a particular OP's question. Therefore the code isn't generic, it is designed for a specific situation, like most examples! However I hope there's enough information here for you to follow what's happening. Multiple...

www.niftyaccess.com

 

[MajP]

Something like this?

 

[access2010]

This isn't the answer to your question, it's a different way of generating multiple reports which I thought you might find of interest..

Generate Multiple Reports - Nifty Access

Generate Multiple Reports This blog came about because of an answer I gave to a particular OP's question. Therefore the code isn't generic, it is designed for a specific situation, like most examples! However I hope there's enough information here for you to follow what's happening. Multiple...

www.niftyaccess.com

Thank you, Uncle Gizmo, your link that gives us a great opportunity for our database development.
Crystal

 

[access2010]

Something like this?

Thank you MajP.
P.E.R.F.E.C.T. for our reports, can we use the same idea to group the same report data on our forms for updating?
Nicole

 

[MajP]

Something like this?

 

[access2010]

Something like this?

P.E.R.F.E.C.T. thank you.
Nicole