Results 1 to 3 of 3
  1. #1
    thexxvi is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    May 2015
    Posts
    63

    Updating a Subform Query using a ComboBox

    Hello,



    I currently have a form that contains a combo box and a subform. The subform is tied to a query that I have set up, and the combo box drives one of the fields in the query.

    Essentially what I'm trying to do is select an item in the combo box and have the subform refresh. The query is set up to look at that combo box for a name. I need the query to refresh once the name is selected in the combobox and I need the subform to display the new query results.

    How can this be accomplished?

    Thank you.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    You have an UNBOUND combobox used to input search/filter criteria?

    Review:

    http://www.allenbrowne.com/ser-62.html

    http://datapigtechnologies.com/flash...tomfilter.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.

  3. #3
    thexxvi is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    May 2015
    Posts
    63
    Thank you June7 - I'm going to take a look at those sites to help me out. The combobox is unbound btw.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-16-2015, 09:28 AM
  2. Replies: 1
    Last Post: 12-10-2013, 03:15 PM
  3. Replies: 1
    Last Post: 09-06-2011, 01:47 PM
  4. Replies: 0
    Last Post: 08-24-2010, 06:38 PM
  5. Replies: 0
    Last Post: 12-16-2009, 01:14 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