Taras

<div>
Adding to the above ,probably (it depends) you could write a &quot;public&quot; function that will have as argument the Form object and a param array with the criteria for your searching...so given the fact that your search would be globally controlled you can easily add a logger to record your searches
</div>


Adding to the above ,probably (it depends) you could write a "public" function that will have as argument the Form object and a param array with the criteria for your searching...so given the fact that your search would be globally controlled you can easily add a logger to record your searches

<div>
Thank you Dale and John I will use yours suggestions.
</div>


Thank you Dale and John I will use yours suggestions.

<div>
<div class="content wysiwyg-content">
In MS Access 2013 front end back end on SQL Server 2014 I have several forms on which I do the Search and pull records on form (not just for edit) it could be just search and show data.<br />
Is there way to record those search occurrences: &nbsp;Who did that &nbsp;and What was search statement? I am not interested in log of changes of record, delete or adding new ones but only in search.
</div>
</div>


In MS Access 2013 front end back end on SQL Server 2014 I have several forms on which I do the Search and pull records on form (not just for edit) it could be just search and show data.
Is there way to record those search occurrences:  Who did that  and What was search statement? I am not interested in log of changes of record, delete or adding new ones but only in search.

MS Access Audit search statements

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.