I have a form that has a series of 5 textboxes where the user inputs some Control Totals info from a printed form that is used elsewhere in my db. I use another unbound textbox on that form to sum the abs(x) of the 5 textboxes.
The amounts in the textboxes can be any number and in fact can be zero. However, IF all of the amounts are zero, I want the user to positively affirm that the amounts should be zero.
So I created a separate form with a label for instructions on the fact that they are verifying that they're all supposed to be zero PLUS a checkbox that the click to say "True" should be zero AND THEN they'll click a control button with the label "Verify All Amounts were Zero".
All of that is working fine. HOWEVER, I don't want them to leave that form or I guess prevent that form from losing focus until they have either:
A)clicked the checkbox AND selected the "Verify" control button OR;
B) click on a "Cancel and Correct Control Totals" control button (which sends them back to the original form to fix.
Hope I've used the correct terminology to make this understandable.
The Control Totals form is - frm_RptgControlTotals
The Verify Zeros form is frm_RptgControlTotals_VerifyZero
The ckbox is ckBoxVerifyZero