Show all records

[DaveLL]

HI all
At the form level a put a trigger( OnApply filter) the macro (showAllRecors)
but for a reason that I don't know, it doesn't work. I use a filter and nothing happened??!
Is there something that i don't get??
Thanks

 

[scking]

Access doesn't have triggers at the form level. I assume you mean an event but you will need to be a little clearer in you explanation, even to the point of pasting in your code.

Steve King Professional growth follows a healthy professional curiosity

 

[DaveLL]

HI
I'll try to be clearer...
When you use a filter in a form( right click )... it shows you the records that results.
And after, if you want to use another filter for example, on all the records of the form, you have to do ShowAllRecords.
What i want to do is : After usage of a filter, I don't want to do Showallrecords.
I try to put that on a macro put it doesn't work
Sorry fot the english!!
thanks