Results 1 to 2 of 2
  1. #1
    dgj32784 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    22

    Dynamic Combo Box - Change Choices Based on Previous Selections


    I have a survey database that contains a combo box drop-down for the surveyors to select their name from to specify who is conducting the survey. This person serves as the "primary" surveyor. There is button that takes them to another form to select any additional surveyors (e.g., observer, qaqc, etc.) from another combo box of names. I think the answer is probably something simple, but how to I dynamically reduce the combo box on the second form based on the value selected for the primary surveyor on the main form? That is, I don't want the primary surveyor's name to show up, cause they cannot also be an observer at the same site.

    Thanks in advance,
    David

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    a combobox's datasource is a query - in its property you can open that query at the ... symbol - and modify that query just as you would any stand alone query

    hope this helps.

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

Similar Threads

  1. Query to Limit Combo Box Choices
    By jimrockford in forum Queries
    Replies: 2
    Last Post: 04-23-2011, 10:24 PM
  2. Replies: 6
    Last Post: 12-20-2010, 04:17 PM
  3. Image change based on combo box
    By bosve73 in forum Forms
    Replies: 4
    Last Post: 08-09-2010, 02:23 AM
  4. Updating subform based on combo box change
    By kev921hs in forum Forms
    Replies: 3
    Last Post: 04-01-2010, 08:43 AM
  5. Replies: 1
    Last Post: 03-27-2010, 06:13 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