Append query for sub form not working

Posted on 2012-08-27
Last Modified: 2012-08-27
Hello all,
I have a a form called "frmMain" I have a subform called "frmInductionChecks".The subform is located on one of the tabs of the main form.

I know that the structure of this form is horrible! but This is the best I could do.

On the button called" Save record" it has two queries that append One for the main form Called "frmMain": DoCmd.OpenQuery "qryappendInductionHistory", acViewNormal, acEdit

 and one for the SubForm "frmInductionChecks"  DoCmd.OpenQuery "qryappendInductionChecksHistory", acViewNormal, acEdit

The append queries have a code on the criteria that suppose to append only the data that it is in each of the form the code in the criteria looks like this for the main form,

and this for the subform, [Forms]![frmInductionChecks]![Serial]

The field for the both forms is "serial".
The main form is appending. but the subform popups showing the criteria,[Forms]![frmInductionChecks]![Serial] like it cant find the form. Experts please help!
 Thanks for all your time and help!
Question by:gigifarrow
    LVL 119

    Accepted Solution

    change the criteria of the query  "qryappendInductionChecksHistory"

    From this


    to this


    Author Comment

    That works!!! Thank you for your time and help!

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    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…

    729 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