Results 1 to 4 of 4
  1. #1
    JasonRkr is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2010
    Posts
    3

    Show Username in dropdown but record UserID in table.

    Hi, all.



    I have a form that collects new users. The user completing the form clicks a dropdown to select the referring user. I want to display the user name in the dropdown, but have it store the userID in table when the record is complete.

    How do I do that?

    Thanks.

    Jason

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    That is typically how you use a ComboBox. Have you tried to let the ComboBox wizard create the control for you? It knows how to do what you want.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    JasonRkr is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2010
    Posts
    3
    Thank you, RuralGuy. I didn't realize it worked like that.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Glad we could help.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. request username and password
    By meysam_e2006 in forum Access
    Replies: 2
    Last Post: 07-02-2010, 02:03 AM
  2. Text Box to show specific record
    By chu3w in forum Forms
    Replies: 1
    Last Post: 04-01-2010, 12:23 PM
  3. Replies: 2
    Last Post: 09-24-2009, 08:07 AM
  4. Replies: 4
    Last Post: 10-29-2008, 11:53 AM
  5. Show a new image per record in a form
    By Bert Colourama in forum Forms
    Replies: 0
    Last Post: 09-25-2008, 05:22 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