Pull Down Menus to bring up reports

[Castanz]

I hope this is really easy, but I haven't figured it out yet. I want to run a report based on a pulldown menu. Right now I have in my queries [Type in the name of the class for the report] in the class colomn. My report uses the query for the record source. To get an accurate class name the user has to copy and paste the name of the class in the field. Classes can vary by one or two letters. Can anyone help me with this. -Thanks, Castanz

 

[jrbarnett]

Take a look at the following posting in which I answered a very similar question the other day and will probably help you understand what you need to do to implement this.

javascriptpenindex(450,350,'

http://www.tipmaster.com/includes/refinfo.cfm?w=450&h=350')

John

 

[jrbarnett]

Sorry - I put the wrong link in. Try this one instead:
thread181-538495

 

[Castanz]

Thanks, JrBarnett
This is the code I used. I didn't have a subform:
Private Sub Open_rep_Click()
On Error GoTo Err_Open_rep_Click

Dim stDocName As String
Dim strWhereCond As String
Dim strDivision As String

stDocName = "Single Division"
strDivision = Me.Division
strWhereCond = "Division='" & strDivision & "'"
DoCmd.OpenReport stDocName, acViewPreview, , Wherecondition:=strWhereCond

Exit_Open_rep_Click:
Exit Sub

Err_Open_rep_Click:
MsgBox Err.Description
Resume Exit_Open_rep_Click

End Sub

I made the Combobox save to a temporary table with a division field. This seemed to work fine.