Results 1 to 3 of 3
  1. #1
    Paintballlovr is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jul 2013
    Posts
    96

    subform not passing value to table


    I'm brand new to subforms, so maybe this is an easy fix. I have a subform that is pulling one of it's values from the main form, which seems to work fine (=[Forms]![Manual Input Form 10 CHECKS]![LB_BatchNum]). It is displaying this number for each entry in the subform, but when I look at the table the subform is writing to, this information is missing. Am I not using the proper method for capturing this number or is there a setting in the properties I need to adjust to capture this number along with the rest of the entry(ies) on the subform?

  2. #2
    Paintballlovr is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jul 2013
    Posts
    96
    I think I found the answer, with the master and child link. I removed the above code to capture the number and used the link instead and it appears to be working. If someone has some input if there is a different/better way to do this, I'd be curious to know. I'll close this issue in a day or so if there isn't any movement. Thanks.

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Presumably the number is show in a text box. The text box should have its Control Source property set to the name of a field in the table that the subform is bound to.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-25-2013, 08:49 AM
  2. Replies: 2
    Last Post: 05-17-2012, 11:19 AM
  3. Replies: 1
    Last Post: 03-28-2012, 04:12 PM
  4. Replies: 3
    Last Post: 05-23-2011, 02:15 PM
  5. Passing focus to subform.....
    By smorelandii in forum Forms
    Replies: 3
    Last Post: 02-04-2011, 10:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums