I need to simplify my report_launch forms

[viperstingray]

***this has already been posted on the report formus...i posted it here also due to its relation to forms***

**********************DO NOT GET MAD**************************

GOOD MORNING...

I currently have a form to launch a set of pre-desinged reports. The main function of the form is that it allows the user to sort or filter the data that appears in the report based on their selection (from combo boxes). I currenty have it set up so that the user can choose a specific client, facility, or region. The problem is the following:

THE FORM IS WAY TOOOO BUSY AND NEEDS TO BE SIMPLIFIED. EX:

CLIENT (combo box)
Microsoft
nortel
dell
ibm
.
.
.
btnLaunchRPT1 btnLaunchRPT2 btnLaunchRPT3

REGION (Combo box)
North
South
East
west
north-west
.
.
.
btnLaunchRPT1 btnLaunchRPT2 btnLaunchRPT3


etc.

each btnLaunchRPT'n' has the following code
DoCmd.OpenReport "rptECM Numbers", acViewPreview, , "[Region] = " & "'" & Me.Combo299 & "'"

but I change the [region] to whatever it is I am sorting by. Can I reduce this down to only having one set of btnLaunchRPT buttons that will detect what the user has selected and applies the proper sorts

HELP

 

[ansentry]

If I read you thread correctly then you need to search here for:

Cascading Combo Boxes

There are a lot a posts relating to them with db's for you to examine.

 

[viperstingray]

well, no. I do not need cascading combo boxes. I already have those. I just want to be able to program my command buttons to launch their respective reports based on what the criteria that was chosen by the user.