I want to add an event on Form Header when double click it will filter the values, which i did with macro, but could it happen on second time double clicking it it refreshes whole as original?
Competent Performer
Windows XP 
Access 2007
I want to add an event on Form Header when double click it will filter the values, which i did with macro, but could it happen on second time double clicking it it refreshes whole as original?
VIP
Windows 7 64bit Access 2010 32bit
What method did you use - setting Filter and FilterOn properties? In VBA, possibly:
Me.FilterOn = Not Me.FilterOn
Have no idea about macro.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Filter Form from header click
On-Click Event Procedure
Posting Permissions
Reply With Quote