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

Posted on 2012-09-08
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

    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

    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!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now