Double Click event of form Header

D

Drunkenneo

Registered User.

Local time

Today, 10:31

Joined

Jun 4, 2013

Messages

192

• Nov 18, 2013

• #1

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?

 

bob fitz

AWF VIP

Local time

Today, 06:01

Joined

May 23, 2011

Messages

4,808

• Nov 18, 2013

• #2

Cross posting. http://www.accessforums.net/programming/form-subform-39428.html
Please read: http://www.excelguru.ca/content.php?184-A-message-to-forum-cross-posters

 

M

Mihail

Registered User.

Local time

Today, 08:01

Joined

Jan 22, 2011

Messages

2,373

• Nov 18, 2013

• #3

Private Sub Header_DoubleClick
Static Filtered As Boolean
Filtered = Not Filtered
FilterOn = Filtered
End Sub