Populate subform based on form getting error cant find form

Posted on 2012-08-26
Last Modified: 2012-08-27
I have a from named "frmMain" I have a subform named "frmInductionChecks"
They both have a field called "serial".

I need the serial number to populate the subform called frimInductionChecks.

The code I have does the opposite and populates the form with what is in the subform here is the code: afterupdate
   " Me!Serial = Me![frmInductionChecks].Form!Serial.Value "( the code is in the field called "serial" on the main form called frmMain)

 but when I change the name of to the main form so it will populate the subform I get an error "can not find form"
   " Me!Serial = Me![frmMain].Form!Serial.Value "
Question by:gigifarrow
    1 Comment
    LVL 119

    Accepted Solution

    try placing this codes in the afterupdate event of the control "Serial" in the main form

    Me.frmInductionChecks.Form.Serial = Me.Serial

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    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…

    734 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

    18 Experts available now in Live!

    Get 1:1 Help Now