Results 1 to 2 of 2
  1. #1
    kelkan is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    26

    update parent form with child form info

    I have a form with a subform on it. The main form has a combo box which filters the data displayed on the subform. I then want to update a field on the main form with information displayed on the subform. Specifically, I have a combo box which displays class titles. After selecting a specific course, the subform displays all available class dates for the selected class. I want to select a date from below and have it automatically entered in the class date field on the main form . How can I do that without actually typing in the desired date?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    The conventional purpose of form/subform is to create related parent/child records. You appear to be using the subform as a combobox would be used. Consider this http://datapigtechnologies.com/flash...combobox2.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 3
    Last Post: 07-03-2013, 01:20 PM
  2. Display info from parent form in child form
    By Leonidsg in forum Forms
    Replies: 3
    Last Post: 03-23-2013, 07:14 PM
  3. Passing value from parent to child form
    By Pragmatic in forum Forms
    Replies: 1
    Last Post: 12-02-2011, 07:23 PM
  4. Replies: 2
    Last Post: 09-16-2011, 06:11 PM
  5. Problem using Parent/Child Form/Subform
    By EvanRosenlieb in forum Forms
    Replies: 4
    Last Post: 06-27-2011, 05:25 PM

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