I have a VB.Net Web Form on which I collect informtion that allows me to modify the WHERE clause of my Select statement.
When I click the OK button confirming my new WHERE clause, I'd like to have the record currently displayed on the screen to be replaced by the first record matching the new WHERE clause.

I also have navigation buttons on the form.
Currently I have to click my "FIRST" button to get the form to update with the content of the first record matching the new WHERE clause.

I've tried calling the "FIRST" button in the code after my WHERE clause session variable is updated, but that's not working. What do I need to do to get it to work?

TIA,
Rick