Results 1 to 4 of 4
  1. #1
    aksnell is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    4

    Auto populate field in subform based on field in parent form


    Hi, I am fairly new to Access. I have created a main form and one of the fields in the main form has a drop down list. I would like to have a different field in the subform auto populate depending on what the user chooses in the drop down list of the main form. Can anyone explain how I would do that?

    Thank you!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Don't understand this requirement. Why isn't the combobox in the subform if that's where value should be saved?
    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.

  3. #3
    aksnell is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    4
    I have a field called "Therapy Type" in the main form. When a user chooses a tharapy type from the look up list, I want a list of people names that are connected to that therapy type to display in a field called "reviewers" in the subform. I do not know how a combo box can do that.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    This is cascading or dependent comboboxes. Normally the two comboboxes are on the same form. See this tutorial http://www.datapigtechnologies.com/f...combobox2.html
    The tecnique should be adaptable to your situation.

    If the subform is in Continuous or Datasheet view, will need some additional code in the subform combobox GotFocus event to requery itself.
    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: 1
    Last Post: 08-11-2011, 06:22 AM
  2. Auto populate a field (without a form)
    By DonL in forum Access
    Replies: 1
    Last Post: 06-21-2011, 03:19 AM
  3. Replies: 3
    Last Post: 12-06-2010, 06:35 PM
  4. Replies: 2
    Last Post: 10-19-2010, 11:05 AM
  5. Replies: 3
    Last Post: 10-05-2009, 07:22 AM

Tags for this Thread

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