Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2013

    Unanswered: Having Trouble woth subforms can anyone help

    I have created a main form and two subforms. On both of the subforms I am looking up name data based on a numeric id from a different table. When I look at the subforms independantly from the main table they lookup the name data correctly. When I drag them into the main table I get the #NAME? error message.

    Can anyone tell me what I am doing wrong?

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 17
    #NAME? means that the data source is not valid/available/found.

    Is the data source for the main form related to the data sources for the sub forms? Have you set up parent/child relationships between the main form and the sub forms?
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    I suspect the 'name data' is not present in the recordsource for the 'main table' but is present in the subform
    a solution is to specify that the 'name data' comes from the sub form

    set the ropwsource appropriately. EG:-
    = forms!mysubform!wahtevryounamedataiscalled

    it does beg the question why you want to store data in a sub table, but then show it in the 'parent table'
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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