Results 1 to 2 of 2
  1. #1
    akyramid is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2011

    Referencing drop down list from form

    I have created a form for cooking recipes which includes the number of servings of dairy,fruit,protein, etc.

    I have created another form for daily meals (breakfast lunch and dinner) where I setup combo boxes with drop down lists of all the recipes.

    How can I set up a query that takes the selected recipes from the drop down boxes in the daily meals form and sums up all the dairy, fruit, proteins for all meals selected?

    FYI - I have tried setting up a query which uses the the recipes table (linked to the recipe form) with the field being dairy or fruit or protein and the criteria references the drop down box from the daily meals form but it always gives me a "0"

    Thanks for your help! I'm hungry!!!

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    I admit upfront that I don't really understand what you are asking.

    You mention forms, but not tables???

    However, I do think this link or others at the site will be helpful

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

Similar Threads

  1. Filter available values in a drop down list
    By petitmorsalin in forum Access
    Replies: 1
    Last Post: 12-13-2010, 09:39 AM
  2. drop down list
    By tceicher in forum Access
    Replies: 5
    Last Post: 08-13-2009, 05:41 AM
  3. Open form from a drop down list
    By ildanach in forum Forms
    Replies: 15
    Last Post: 05-21-2009, 05:40 AM
  4. Open Form with a drop down list box
    By Rinehart in forum Forms
    Replies: 0
    Last Post: 08-10-2008, 08:53 PM
  5. I can't create a drop-down list box
    By cpuser in forum Access
    Replies: 4
    Last Post: 02-18-2008, 10:11 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