Custom Report

[Kapellu2]

Hey everyone. I am writing a program which generates a report based off a combo box. The combo box is in the format show below

Color Width Thickness Length Hardness Elasticity
Item1
Item2
Item3
Item4


The database has around 50 items. Right now I am able to sort using a drop down list, and print out a report for say, every red item. This report will show the width thickness length hardness and elasticity for all of the red items. I was wondering if there was a way using check boxes or something to be able to generate a customizable report. I would like it to be able to print out reports listing only chosen variable. An example would be to tell it to print a report that just shows all of the blue coolers, and their thickness. Or all of the blue coolers, and their hardness and elasticity ect. Is this doable?

 

[KenHigg]

My first thought here is to create a custom sql statement based on the entries in controls placed on an unbound form - Does this make sense?

 

[Kapellu2]

Haha sorry i'm pretty new to access, the majority of that was a little over my head

 

[KenHigg]

Are you working with 2003?

 

[Kapellu2]

Yes, we have Access 2003.

 

[KenHigg]

Sorry for dragging this out - Have you ever done any VBA?

 

[Kapellu2]

No worries. And i've just started learning VBA over the past few weeks so im fairly new to it. Had a little experience with java tho

 

[KenHigg]

I was just going to say I can show you some sample code that should work but you'll have to adapt it to your situation. If you don't know VBA or sql then it could get complex fast - ??

 

[Kapellu2]

Yeah if you could throw out some sample code that would really help.