Help With Printing A Report Based Off A Query.

Hi all..

I have a drop down list on a form that prints a report based off of the selection in the cbo box...

(I have already changed the query and relationship for the lookup and maintable)

Here is the code that works fine,(this is on a command button)

Private Sub cmdViewStreet_Click()
stDocName = "rptStreetName"
On Error Resume Next
DoCmd.OpenReport "rptStreetName", acViewPreview, acEdit
Me.cboStreetName = Null
End Sub


What I am doing now.. is this: the look up table that had the street names but did not have an autonumber or primary key. I added in a autonumber and primary key. I can get the cboStreetName to list the street names and not the autonumber.. and I can get the main table to store the autonumber not the street name (this is what I want).. but now I can't get it to view what is in the cboStreetName... When I hit the view button it does nothing... Any suggestions?? If you need more info please let me know...

I tried something like this to:

Private Sub cmdViewStreet_Click()
On Error GoTo Err_cmdViewStreet_Click
Dim stDocName As String
stDocName = "rptStreetName"
DoCmd.OpenReport "rptStreetName", acPreview, , "[StreetName]=" & Me.cboStreetName.Column(0)
Exit_cmdViewStreet_Click:
Me.cboStreetname = Null
Exit Sub

Err_cmdViewTitle_Click:
MsgBox Err.Description
Resume Exit_cmdViewTitle_Click

End Sub


R~