If...then...else statement in report

[medic133]

I am trying to use one report for two queries instead of creating additional reports for additional queries. Essentially, all I want to do is use an If...then...else statement in my report to set which query the report is based on. In the Report_Open section of code for my report I have the following VBA code:

Dim qdf As QueryDef
Set dbsReport=CurrentDb

If [forms]![formname]![fieldname]="(string)" then
Set qdf=dbsReport.QueryDefs("queryname1&quot
qdf.Parameters("(query specific parameters)&quot
Set rstReport=qdf.OpenRecordset()
Else
Set qdf=dbsReport.Querydefs("queryname2&quot
Set rstReport=qdf.OpenRecordset()
End if

My queryname2 is the same query as queryname1 without parameters, if that matters. My problem with this code is that even when the if...then statement is not satisfied, it is still carried out, which returns no data. I know this, because I display a message box on the No Data event and I have confirmed that my queryname2 has data. It seems that the ...else portion of my statement is never carried out. Any ideas on how to fix this? Thanks in advance!!

 

[mp9]

What are typical values of "(string)"?

http://www22.brinkster.com/accessory/

 

[medic133]

("string&quot is set to either "Clinical" or "Internship" depending on a command button a student clicks. Clicking on a command button populates a textbox with either "Clinical" or "Internship". From here the student can click on another command button which is based on a query which has as a parameter based on the value of the above textbox. The report lists several totals from the query. I can easily use this report for the above query. What I would like to do is use the same report for a query that doesn't have the above parameter (in other words a query which totals values for both intership and clinicals-these are paramedic students). This will save me tons of room in my database if I don't have to have double the number of reports.

Thanks!!