Populate subform based on form getting error cant find form

Posted on 2012-08-26
Medium Priority
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 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 38335157
try placing this codes in the afterupdate event of the control "Serial" in the main form

Me.frmInductionChecks.Form.Serial = Me.Serial

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

807 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