wherecondition argument to open Report

[ecugrad]

Question. I have two combo boxes named Quarter and Dept. I'm trying to use the selections of the above to open a report using the WhereCondition argument. Can somebody tell me where I'm going wroung with the code below. The Me.Quarter but the Me.Dept does not..

If Me.Quarter = "qtr12002" Then
DoCmd.OpenReport "rptqtr12002", acViewPreview, wherecondition:="Section" = Me.Dept

Thanks
MF

 

[ecugrad]

Figured it out, Thanks...

If Me.Quarter = "qtr12002" Then
DoCmd.OpenReport "rptqtr12002", acViewPreview, wherecondition:="Section = Forms![frmDataAdministration]![Dept]"

 

[scking]

I believe lots of places. You are attempting to use a single named parameter 'WhereCondition:=' when there are really three parameters. Access does not work that way. You can use named parameters only if ALL the parameters are named, so your 'rptqty12002' and acViewPreview would also need to be named. Then, you WhereCondition parameter has at least two errors. First, the equal sign need to be inside the quotes and second, you need to place the Me.Dept inside quotes since it is text.

WhereCondition:="Section = '" & Me.Dept & "'" ----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------