Converting My filters into a text string
Posted on 2011-02-27
A slightly different question.
I have a continuous form.
I will apply some standard Access filters to this form.
E.g. Show all records where Product = "Widget"
I want to write a log to a one field audit table in the format ;
"28/02/2011 17:22:20 Filter Applied : Product = Widget"
How do I capture the "Product = Widget" as a piece of text. It does not have to be exactly in this format - I merely want to record the details of the filter applied.
I am hoping that there is a simple solution for this. If it is very complex than it might not be worth my while.