Results 1 to 4 of 4
  1. #1
    ZodiacPilot is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Location
    Dayton, Nevada
    Posts
    28

    Linking a table to a query for use in a combo box how do I do it? I am trying to create a filter.

    I have a table with values I wish to use for a combo box. I want to return all records with the combo box selections to my form using values from a different query.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    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
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    build a query for your combo box. assign it to the combo.rowsource.
    the FORM is bound to a different query. the combobox is connected to a field on the form USING values from the combo .

  4. #4
    ZodiacPilot is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Location
    Dayton, Nevada
    Posts
    28
    Thank you all for your assistance. I solved my problem by combining the field value from my table to the values in the existing query
    and defining the new query with a new name.

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

Similar Threads

  1. Replies: 1
    Last Post: 08-13-2015, 12:05 PM
  2. Replies: 3
    Last Post: 06-18-2014, 10:40 AM
  3. Urgent: How to use a combo box to filter a table
    By roshani007 in forum Access
    Replies: 1
    Last Post: 06-17-2014, 08:31 AM
  4. Create a Query that won't mess up when linking a new table
    By DavidMichaelangelo in forum Queries
    Replies: 12
    Last Post: 11-25-2013, 12:24 PM
  5. Combo box and filter query
    By thart21 in forum Forms
    Replies: 7
    Last Post: 04-06-2010, 11:37 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