can't filter report in Access2000

[olle]

hi everyone.
I have this code to apply the filter on a form to a report.
In Access97 it worked fine but when I converted it to Access2000 the
report shows all records in the table. What has happened?

this is the code:
strGlobalFilter is a global valiable
if me.filter = "" then
MsgBox "Apply a filter to the form first."
Else
strGlobalFilter = me.filter
DoCmd.OpenReport "rptLeads", acViewPreview
End If
in the report's "OnOpen" event:
DoCmd.ApplyFilter, strGlobalFilter

It shows now all the records
Thanks för any help
/Regards BigOlle

[Gox]

ol**@ylm.se wrote:

hi everyone.
I have this code to apply the filter on a form to a report.
In Access97 it worked fine but when I converted it to Access2000 the
report shows all records in the table. What has happened?

this is the code:
strGlobalFilter is a global valiable
if me.filter = "" then
MsgBox "Apply a filter to the form first."
Else
strGlobalFilter = me.filter
DoCmd.OpenReport "rptLeads", acViewPreview
End If
in the report's "OnOpen" event:
DoCmd.ApplyFilter, strGlobalFilter

It shows now all the records
Thanks för any help
/Regards BigOlle

On form try this:

DoCmd.OpenReport "rptLeads", acPreview, , strGlobalFilter

without "OnOpen" event on Report.

It must work!

--
Gox

[olle]

Hi Thanks a lot.
Now it works perfekt.
I made it work after adding two commas, ( ,, ) after acPreview
DoCmd.OpenReport "rptLeads", acPreview, , strGlobalFilter

Super
/Regards BigOlle