What's wrong with this URL button formula

Question

I am trying to check a checkbox field by clicking this URL Formula button on a record in a report without opening the record to a form and then stay on the report. This worked wonderfully with a javascript rich text button...but....URLRoot() &amp; "db/" &amp; [_DBID_PLC] &amp; "?act=API_EditRecord"&amp; "&amp;rid=" &amp; URLEncode ([Record ID#])&amp; "&amp;_fid_46=1"&amp; "db/" &amp; Dbid() &amp; "?a=doredirect&amp;z=" &amp; Rurl()I am getting this error:This XML file does not appear to have any style information associated with it. The document tree is shown below.
&lt;qdbapi&gt;

&lt;action&gt;API_EditRecord&lt;/action&gt;

&lt;errcode&gt;0&lt;/errcode&gt;

&lt;errtext&gt;No error&lt;/errtext&gt;

&lt;rid&gt;1579&lt;/rid&gt;

&lt;num_fields_changed&gt;0&lt;/num_fields_changed&gt;

&lt;update_id&gt;1626883497807&lt;/update_id&gt;

&lt;/qdbapi&gt;
Style information? What do I need to add to this formula to get it to work?------------------------------George Bramhall------------------------------

michaeltamoush · Answer

I believe the redirect is incorrect. Try this.

URLRoot() & "db/" & [_DBID_PLC] & "?act=API_EditRecord"& "&rid=" & URLEncode ([Record ID#])
& "&_fid_46=1"
& "&rdr="
& URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl())

------------------------------
Mike Tamoush
------------------------------

georgebramhall1 · Answer

Bingo! Worked like a charm. Thanks Mike!------------------------------George Bramhall------------------------------

Forum Discussion

What's wrong with this URL button formula