Enable all records

[ScottXe]

I have a search form based on a query. The query has a on/off field and default is on. The criteria of the query is to show the records in on status. I would like to have a command button to show all records including off status records at times. The button should have toggle function: first click on and second click off. What sort of required code to be put in on click event to achieve this function? Thanks!

 

[plog]

Check out the Form.filter property: https://msdn.microsoft.com/en-us/library/office/ff194672(v=office.15).aspx

Set the filter to the approprite criteria. Then if its off, turn it on. If its on, turn it off.

 

[ScottXe]

Thanks for your advice and I have built the command button to set the filter to false successfully.

I will continue to see how to add visual indication if in filter on or off status and have the the on and off cycling function.