Results 1 to 9 of 9
  1. #1
    AccessBlues is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Aug 2011
    Posts
    5

    Subform requery after multiple records selected

    I need a subform to requery so it pulls all of the records associated with multiple selections chosen in a separate subform, rather than a single selection.



    In one subform (subformEXIndicators), users identify up to 5 "indicators" associated with a particular video clip using the control EXINIndicator.

    In a separate subform (subformEXMarkers), users select the "markers" associated with the video clip using the control EXMAMarker.

    Each "indicator" has from 2-5 "markers," so what I'd like to do is have EXMAMArker (or subformEXMarkers) query subformEXIndicators so that the markers for ALL of the indicators entered on subformEXIndicators are listed in its combo box drop-down list.

    Currently, I have a requery for EXMAMarker in VBA, but it only allows for the markers associated with the last indicator entered to come up. Here's the code:
    Private Sub EXINIndicator_AfterUpdate()
    Forms!ExemplarEntry!subformEXMarkers!EXMAMarker.Re query
    End Sub

    Thanks for any suggestions you can offer! This is my first post, so if there's needed info I've leaving out, please let me know.
    Last edited by AccessBlues; 08-02-2011 at 11:53 AM. Reason: Requery has an extra space

  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
    EXINIndicator is a listbox that allows multi-selection? Think have to use VBA code to cycle through the listbox and build an SQL filter string that would be used to dynamically set the RowSource property of EXMAMarker.
    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
    AccessBlues is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Aug 2011
    Posts
    5
    It's a combo box. There's another control on subformEXIndicators requiring additional input for each indicator, so I wasn't able to use a list box.

  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
    I am not following your setup. I haven't made use of multi-select listboxes and don't even know how a combobox can be multi-select. Hope someone else contributes.
    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.

  5. #5
    AccessBlues is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Aug 2011
    Posts
    5
    The combo box doesn't have a multi-select option --- it's used in a subform, so users can use the combo box to enter a record, then use it again to enter a second record, a third record, and so on.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    These subforms are on same main form? Are these subforms linked to records on the main form by the Master/Child property settings of the subform container?
    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.

  7. #7
    AccessBlues is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Aug 2011
    Posts
    5
    Both subforms are on the main form, ExemplarEntry, and are linked to the main form by the master/child property settings.

    I need subformEXMarkers (or the combo box control on that subform, EXMAMarker) to query all of the EXINIndicator records entered in subformEXIndicators, so that it pulls all of the associated markers for all the indicators entered.

    Thanks for your continued assistance and patience on this. If you need more info let me know --- as a novice user I'm not sure what additional info I need to provide.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Sounds like something I've never seen attempted. Think you better attach project for analysis. Or at least an extract of the relevent tables and forms. Run Compact & Repair first, zip if large.
    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.

  9. #9
    AccessBlues is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Aug 2011
    Posts
    5
    Will do --- thanks!

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

Similar Threads

  1. Replies: 4
    Last Post: 07-07-2011, 03:21 PM
  2. Show selected records in subform
    By Papilion in forum Forms
    Replies: 8
    Last Post: 06-18-2011, 07:41 AM
  3. Prepopulate subform with multiple records
    By Erik Feenstra in forum Forms
    Replies: 1
    Last Post: 05-02-2011, 07:28 AM
  4. Refresh Requery Subform
    By eww in forum Programming
    Replies: 1
    Last Post: 04-05-2011, 09:19 AM
  5. Adding multiple records in subform
    By randolphoralph in forum Programming
    Replies: 1
    Last Post: 05-12-2010, 09:42 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