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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Access 2007 Apply Filter 3
Applyfilter in Access 2007 2
form requery, first record problem 11
Weird Filtering Problem?? 3
Assign Default Filter In Access Form 2
Filter Somehow Got Turned On 4
Runtime 2007 filtering my filter 0

Top