Results 1 to 3 of 3
  1. #1
    Awaleed is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Aug 2015
    Posts
    3

    using combo-box to show only remaining items

    I want to use combo box to select the resources to assign, but want to only show the remaining item, each time I click for new record.


    for example staff allocated for different jobs.
    seat assigned to each person, so each time the free seats only be displayed in the list, Not the already assigned.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,328
    Q1, make a query that pulls all the jobs already picked. (unique list, no dupes)
    Q2, take the table that has all the jobs and join it to Q1.
    Make it an OUTER join, bring down JOB from both table/queries, where ALL jobs in Job table, and some in Q1
    under the criteria for Q1.jobs, set it to: IS NULL.

    Now Q2 will give you all the jobs that ARENT picked yet.

  3. #3
    Awaleed is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Aug 2015
    Posts
    3
    Thanks for the Help, Appreciate your swift response.
    It worked...

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

Similar Threads

  1. Hide/Show a row on a multiple items form
    By Historypaul in forum Programming
    Replies: 10
    Last Post: 04-20-2014, 10:34 PM
  2. Form design to show items on an order
    By snipe in forum Forms
    Replies: 6
    Last Post: 01-31-2014, 02:01 PM
  3. Replies: 5
    Last Post: 10-28-2012, 03:26 AM
  4. Replies: 5
    Last Post: 03-12-2012, 02:58 AM
  5. Simple query to show when items are not checked?
    By mrwistles in forum Queries
    Replies: 28
    Last Post: 09-02-2010, 02:52 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 - Senior Forums