Thanks for the quick response. Unfortunately, that option is not checked for this table and would not resolve the problem.
The form has a button and if clicked the record should be cancelled (not saved), the QB window should redirect to the table's homepage and another tab opened with the window the link pointed them to. It sounds like something a formula-URL could handle. I just didn't see anyway of mimicking the cancel button with a formula, or javascript.