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