Results 1 to 6 of 6
  1. #1
    Accessuser67 is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    35

    Lookup Boxes


    Do you happen to know how to get a lookup box in a form to return two values instead of just one value?

    regards,
    ekmoorhead

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    in Access 2010 there is a multi value field type - you can explore that as a solution.

    otherwise a combobox is essentially the data from a query - you can manipulate that query design.

    hope this helps.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Quote Originally Posted by Accessuser67 View Post

    ...how to get a lookup box in a form to return two values instead of just one value...
    There are several ways this question can be interpreted; you need to give us a better explanation of what you mean by "return two values instead of just one."

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Accessuser67 is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    35
    Quote Originally Posted by Missinglinq View Post
    There are several ways this question can be interpreted; you need to give us a better explanation of what you mean by "return two values instead of just one."

    Linq ;0)>
    I have 2 tables one for recording grocery receipts receipts tbl which includes date, item, qty, amount and total; the other table is category tbl which includes category and aisle. What I want is a form to use to input my grocery receipts where when I enter the item the associated category and aisle will automatically be included in the form.

    regards,
    ekmoorhead

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Please show us your tables.

    Each grocery item has a specific category and aisle?
    I think the issue here is that "lookup boxes" is not conveying your intent - at least not to me.

    I see a generic model, and only pieces of it seem to be applicable to your situation.

    Customer-->Order--->OrderItem<-----Groceries<-----Category<--Aisle

    Are you simply recording some info into a Table, or are you calculating the OrderTotals based on the Price and Quantity of groceryItems purchased by Customer??

    Normally in data base you would not record Total, you would calculate as needed by means of a Query.
    As othrs have aid, a better description, with examples, may improve communications and help resolve your "issue".

  6. #6
    Accessuser67 is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    35
    Thanks I will look into it.

    regards,
    ekmoorhead

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

Similar Threads

  1. Replies: 9
    Last Post: 06-04-2014, 10:45 AM
  2. Help with lookup
    By jcrispy3 in forum Access
    Replies: 9
    Last Post: 11-16-2011, 01:29 PM
  3. lookup
    By mmori in forum Forms
    Replies: 1
    Last Post: 03-25-2011, 06:14 PM
  4. lookUp
    By Balen in forum Access
    Replies: 2
    Last Post: 08-08-2010, 02:09 AM
  5. Lookup
    By neon'00 in forum Forms
    Replies: 2
    Last Post: 04-14-2007, 01:19 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