Combo Boxes (1 Viewer)

[Jade]

Hi There,

I was wondering if anyone could help me. I have a combo boxes that has four choices to choose from: A,B,C and D. you click on one and the report for that choice would come up. Now I need to be able to choose All and have the report come up with all the data for A,B,C and D.

Any suggestions?

Thanks,
Jennifer

 

[Jack Cowley]

Code similar to this in the After Update event of the Combo box should work:

Select Case Me.ComboboxName

Case "A"
DoCmd.OpenReport "ReportA"
Case "B"
DoCmd.OpenReport "ReportB"
Case "C"
DoCmd.OpenReport "ReportC"
Case "D"
DoCmd.OpenReport "ReportD"
Case "All"
DoCmd.OpenReport "ReportA"
DoCmd.OpenReport "ReportB"
DoCmd.OpenReport "ReportC"
DoCmd.OpenReport "ReportD"

End Select