Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Access - Form with a 2nd Seperate Form to Postively Verify if all amounts zero.

Posted on 2012-09-08
Medium Priority
Last Modified: 2012-09-08
Hello All

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
Question by:wlwebb
LVL 29

Accepted Solution

IrogSinta earned 2000 total points
ID: 38379456
Set both the ControlBox and CloseButton properties to NO so that there is no X in the upper left corner for a user to click.  Then set the Modal property to YES so that they cannot click on any other form without this one closing first.

Author Closing Comment

ID: 38379476
Irog, Great!  Haven't worked with Modal before.... I had done the ControlBox and buttons to No ....  Just didn't know how to keep them from clicking too many times and that window getting buried behind other windows without them answering.


And Thanks for always being so quick with responses!

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question