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

    listbox help


    Hello! in my form, and table for that matter, i have a field called, User_Type. This field is what shall be used in a form for someone to click on what type of user they are when they "login". An example of this would be like "Student Employee". I don't know how to go about doing this, so I thought that some brilliant minds might be able to trunce my conundrum. Also, any information that I might need, like all possible user types, if i need to know these things, then please say so right away so i can begin getting that list. Thanks to all who respond, and for those who only looked, thanks for looking!

  2. #2
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    I would set up a user type table (to keep things normalized) and then have a user type id in your table for the user...

    That way you can add user types ad infinitem, ad nauseum as often as you like.

  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
    thanks, but i think i just figured it out on my own, i simply went into the design mode for the form, clicked listbox in the design tab, then clicked the Use Control Wizards, then after clicking on the form, the wizard took me through the process of me putting what i wanted the options to be and what field I wanted them to be input into. thanks for the attempt though lol.

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

Similar Threads

  1. Listbox Help
    By allykid in forum Programming
    Replies: 2
    Last Post: 03-30-2011, 06:17 AM
  2. Listbox on reprot
    By alFReD-NSH in forum Access
    Replies: 0
    Last Post: 03-27-2011, 06:48 AM
  3. What is wrong with my listbox?
    By Buakaw in forum Access
    Replies: 4
    Last Post: 02-21-2011, 03:08 PM
  4. Horizontal listbox - ?
    By bane in forum Forms
    Replies: 3
    Last Post: 04-20-2010, 06:48 PM
  5. Replies: 3
    Last Post: 04-14-2010, 10:00 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