I have a query with a button on each row. If the user clicks that it will toggle a value from Yes to No. The problem is, that there are 100's of rows, so if the user is on the 3rd or 4th page, and click it, the query will refresh and bring them back to page 1. Anyway to stop this and just leave the query on the page the user scrolled to? I am attaching an image of the query incase I am not explaining it well.
Thanks
Bruce
