CancelFilter ?

[יריב החביב]

Hello,

I am in a form that i filtered when i opened it.

Now i want to see all the record.

What should i do ?

 

[Daniel Pineault]

In vba you'd use
Me.FilterOn = False

or simply in your form click on the 'Remove Filter' (lloks like a dark grey
filter) button from the Table/Datasheet toolbar.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[יריב החביב]

thank you
--
תודה רבה

In vba you'd use
Me.FilterOn = False

or simply in your form click on the 'Remove Filter' (lloks like a dark grey
filter) button from the Table/Datasheet toolbar.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.