Results 1 to 2 of 2
  1. 09-22-2011, 02:55 PM #1
    kman42
    kman42 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    40

    Combo box based on table plus 'All'?


    Is there a way to base a combo box on a table and include a value at the beginning called 'All'? I'm filtering a subform based on the combo box. The combo box looks up a set of people, but I need to be able to show the complete set of records for everyone as well.
    Reply With Quote Reply With Quote
  2. 09-22-2011, 03:51 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    http://access.mvps.org/access/forms/frm0043.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Query based on combo box
    By hawkins in forum Queries
    Replies: 10
    Last Post: 08-19-2011, 05:27 PM
  2. Populate combo box based on selection from another combo box
    By ryonker in forum Forms
    Replies: 4
    Last Post: 01-24-2011, 07:11 PM
  3. Filtered Combo Box in Subform based on Combo Box in Main Form
    By Dip8324 in forum Forms
    Replies: 5
    Last Post: 01-02-2011, 10:09 AM
  4. How to make query based on external access DB's table and the table in linked table?
    By aquaraider in forum Queries
    Replies: 2
    Last Post: 10-27-2009, 07:09 AM
  5. Limit combo box 2 values based off of combo box 1 selection
    By jmartin in forum Forms
    Replies: 1
    Last Post: 08-26-2009, 10:45 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums