Microsoft Access Sub Forms

Posted on 2011-10-03
Last Modified: 2012-05-12

I am trying to create a form to be used for call monitoring and quality violations. The goal is to have a form  to be able to capture multiple quality violations with the same call monitoring form. So if a supervisor is scoring a customer call, and notices 3 quality violations on the call, how would I go about creating a form to have one call monitoring score, but have3 quality violations associated to it?

Question by:dplowman
    1 Comment
    LVL 61

    Accepted Solution

    It sounds like you need a mainform/subform setup.

    Take a look at the tutorial here:

    You could have a mainform to show calls, and a sunform to log violations on the call.  The main and subforms would be linked by a call ID.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    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

    20 Experts available now in Live!

    Get 1:1 Help Now