Access 2007 Apply Filter problem

T

troy23

I had this working in all previous versions of Access, but 2007 seems
to be causing a problem.

I load my form and it shows all the records fine. I then have some VBA
code to do an ApplyFilter and all is well and the record is filtered.

I then click another button which runs a show all records command.
When I try the same apply filter again, this time I get a blank
record. Any further filters I do after running show all records in VBA
results in more blank records.

Any advice appreciated

Thanks
 
Top