Formula URL to change field and return to report with same selection criteria
Hi
I have a URL formula that in a table report that opens up a form, to allow the user to update a particular field on the selected record; that part works fine:
URLRoot() & "db/" & [_DBID_OB_XXXX & "?a=er&dfid=11&rid=" & [Record ID#]
Once they've done and click save, I want the user to be returned to the report from which they clicked the URL button, with the same selection criteria that they had in operation when they pressed the url. I've tried a few tricks but haven't managed to get any of them to work. The user has selected a date to run the report, and that date is in a field in the record on which they pressed the URL; so if it was possible to maybe use nexturl to open the original report but pass that date on to the report so it opens the exactly as it was, that would be great; I just can't figure out a way to do it. The user's got to edit a number of records this way for the same date, and if (as it does with everything I've tried thus far) it opens the report with no selection criteria, it's pretty tedious for them.
Any suggestions welcomed..
------------------------------
Jonathan Spencer
------------------------------