filtering report (with subreports) using multiple parameters

[notaloser]

hey there

i have a main PatientForm that contains patient information from multiple tables:

[GENERAL] values
Subform - [RefMD] values (referring doctor)
Subform - [Drugs] values (prescribed meds)
Subform - [Diagnosis] values (medical diagnosis)
Subform - [Encounters] values (visits to the doctor)

what i have is a form (image attached) and i need to be able to select any combination of parameters (including state, zipcode from GENERAL, i.e. referring doctor last name from RefMD, Drugname from Drugs, Diagnosisname from Diagnosis, and VisitType from Encounters) and filter PatientForm where all the selected parameters are true..

does that make sense?

all tables are linked using the field HistNum

how do i code this? i am pretty lost right now

 

[notaloser]

anyone? i was hoping the picture would clarify my problem enough that someone advanced could help me out quickly

 

[CEH]

See if this might help you...... Keep in mind I didn't put any type of error messages for when no match is found... You would want to do that..... But this might get you goin in the right direction.