navigating back to table after updating record

  • 0
  • 1
  • Question
  • Updated 6 years ago
  • Answered
Hi. I have a general problem navigating back to the full report view after I have edited and saved a record. It is never easy or direct and it always takes me back to the top of the table and not the record I left off. How do I do this easily?
Photo of Lynn

Lynn

  • 0 Points

Posted 6 years ago

  • 0
  • 1
Photo of Mark_Shnier

Mark_Shnier

  • 640 Points 500 badge 2x thumb
I see what you mean. I have two suggestions.
The first is that if you are intending to walk down the whole report, then you can edit the first record and then use the Save and Next button (its a split button that starts off being just the Green Save button.

But if you want to pick and choose your records to edit, then i suggest that you make yourself a URL formula button to edit the record but do that in a new window. So the process would be to click the button, edit the pop up tab, and the close that window. You will be dropped back right where you were on the original tab.

The URL formula would be
URLRoot() & "db/" & dbid() & "?a=er&rid=" & [Record ID#]

Be sure to check the box in the field properties to open in New Window. The formula assumes that the fields that holds your record ID# is still called [Record ID#]