H have a split form with 3 search fields made with text box controls , I want to create clear button which resets all filters, How can I do it? I searched online, youtube, no luck
Any help
Thanks
H have a split form with 3 search fields made with text box controls , I want to create clear button which resets all filters, How can I do it? I searched online, youtube, no luck
Any help
Thanks
These textboxes must be UNBOUND. Code would set them to Null.
Are you setting Filter and FilterOn properties to filter form?
Me.FilterOn = False
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.
Me.FilterOn = False
worked
Thanks
Filter it reset itself, however the data in textbox remains
I found my answer
example Me.Text87 = ""
Thanks
I prefer setting to Null instead of empty string.
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.