How can I have a URL button return to where ever it was clicked from? Like same report or homepage that has the report.

no problem. make a formula variable called,  (I suggest),  URL and then continue the formula box with the javascript refresh syntax.


var text URL = 
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Record ID#] &
    "&_fid_11=Complete";


"javascript:" &
"$.get('" & 
$URL & 
"',function(){" &
"location.reload(true);" &
"});" 
& "void(0);"



Don't worry that you don't understand that javascript stuff.   It just executes the formula variable called URL and refreshes whatever page you were on.  It's magic.