Re: How to check a check box by clicking a button
Search the apps for one called 'Magic Buttons' from Kirk Trachy. All kinds of great examples in there, including exactly this. This is the code for checking and unchecking a box, then displaying the record.
------------------------------
Mike Tamoush
------------------------------
|
If([Checkbox Field] = false, URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] & "&apptoken=xxxxxxxxxxxxxxxxxxxxxx" & "&_fid_59=1" & //this is the checkbox field "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]), URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxxx" & "&_fid_59=0" & //this is the checkbox field "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])) // Press the button and this changes the "Checkbox" to checked and returns to display record mode // Press it again and this changes the "Checkbox" to unchecked and returns to display record mode |
------------------------------
Mike Tamoush
------------------------------