Access2007 Form_ApplyFilter event

M

Mark Andrews

I am attempting to use the datasheet functionality in Access2007.

When a user either filters the datasheet or sorts the datasheet the
Form_ApplyFilter event is called.

I have code:
Private Sub Form_ApplyFilter(Cancel as Integer, ApplyType as Integer)
Me.cmdShowAll.Visible = True
end sub

The idea is after filtering the form will show less than all the records (at
least the majority of times with filtering). When this happens I display
the button that lets the user SHOW ALL records.

However if the user just SORTS this same event is called.

What would be the best way to NOT SET my cmdShowAll button to visible?
Coudl I capture before and after filter and orderby properties somehow
etc...?

Thanks in advance,
I couldn't think of an easy way,
been a tough day and my brain is not working so well,
Mark
 

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

Top