Problem with Where Clause/Filter in a Report

A

Antonio

Hi,

I need to print the individual information of one given project. All the
projects are stored in a table and I have a report that will print all the
projects in a table, unless I filter the data.

I have a control button in a form which will open the report like this:

'---------------------------------------------------------------------
Private Sub PrintProjectInfo_Click()
Dim Filtro As String Filtro = "ProjectCode = '" & Me.[ProjectCode] & "'"
DoCmd.OpenReport "PM0630PProspectDetail", acViewPreview, , Filtro
End Sub
'---------------------------------------------------------------------

However, the report still shows all records in the table. Note that there
isn't any filter/where in the report query. I've tried Where Clause and
Filter, but nothing...

Anyone?

Thanks

Antonio
 
Top