Results 1 to 3 of 3
  1. #1
    imintrouble is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    Missouri, where frownin's a sport
    Posts
    127

    Dropdown list

    Hello,

    In my table i have a column which holds certain pieces of data like "Returned" "Bad Address" etc...

    I was wondering if it would be possible for me to create a dropdown list INSIDE of the table. Not a form, but in the table. I know, crazy right?

    A yes or no to if i can even do this is acceptable. However if it is, then i'd appreciate the "how" part of this equation.

    Best,



    Imintrouble

  2. #2
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by imintrouble View Post
    Hello,

    In my table i have a column which holds certain pieces of data like "Returned" "Bad Address" etc...

    I was wondering if it would be possible for me to create a dropdown list INSIDE of the table. Not a form, but in the table. I know, crazy right?

    A yes or no to if i can even do this is acceptable. However if it is, then i'd appreciate the "how" part of this equation.

    Best,

    Imintrouble
    You can... BUT it is generally considered a bad thing to do.

    See:

    http://access.mvps.org/access/lookupfields.htm


    So the answer is: Yes you can; No you shouldn't!

  3. #3
    imintrouble is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    Missouri, where frownin's a sport
    Posts
    127
    Ok, but what about a box in a table, that looks up it's contents from another table. This way I can try and stay away from typos when entering my information.

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

Similar Threads

  1. Replies: 3
    Last Post: 01-18-2012, 12:26 AM
  2. Dropdown list
    By stratack in forum Access
    Replies: 1
    Last Post: 07-25-2011, 06:58 AM
  3. Dropdown List: Use Each Item Once?
    By Heavy Doody in forum Access
    Replies: 1
    Last Post: 05-02-2011, 07:44 AM
  4. Set up a dropdown List
    By asherbear in forum Access
    Replies: 2
    Last Post: 06-24-2010, 06:45 AM
  5. Dropdown list in a query
    By asherbear in forum Queries
    Replies: 6
    Last Post: 05-31-2010, 06:38 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