Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    9

    Unanswered: Retreive data from a subform

    Having a problem retreiving data from a subform. I know that from form "DataEntry" and field "ID", it's forms.[DataEntry].[ID]

    I need to get the data from a subform - say subform Name, field FirstName. Access says to use "Forms![Orders]![Orders Subform].Form" But I've tried a few different ways, and cannot get the data from subform[Name].[FirstName] on form [DataEntry]

    Thanks in advance!

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    where is the code running - ?? in the mother form ?

    then have a go with:
    Me.NameOfTheSubformControlWhichMayNotBeTheSourceOb ject.Form.NameOfControlOnTheSubform

    izy


    ....and the <space> after 50 chars is site-induced and was not there in my original


    LATER: this shows how to talk to forms/subforms from x
    Last edited by izyrider; 05-03-06 at 14:09.
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •