Results 1 to 2 of 2
  1. 09-11-2012, 11:31 PM #1
    cptNemo
    cptNemo is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    10

    Listbox that passes to database values that are different from shown items


    Hello,

    Simple problem.

    I am trying to create a list box that passes to the database a value that is different from what shown in the drop down list. For instance, I want to show the users a drop down list with "Yes" and "No", but then storing into the database "1" when "Yes" is selected and "2" when "No" is selected.

    Thanks!
    Reply With Quote Reply With Quote
  2. 09-11-2012, 11:49 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,898
    Review http://datapigtechnologies.com/flash...combobox3.html

    Applies to combo and list boxes.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Two passes through report's control source?
    By GraeagleBill in forum Reports
    Replies: 2
    Last Post: 09-03-2012, 05:50 PM
  2. Filter items shown in Combo Box in sub-form
    By mikeha_99 in forum Access
    Replies: 2
    Last Post: 06-14-2011, 12:54 PM
  3. How do I get a count of items in a ListBox ?
    By KathyL in forum Forms
    Replies: 8
    Last Post: 05-24-2011, 03:41 PM
  4. Save items from listbox selections to display on another form and save in table
    By taya621 in forum Forms
    Replies: 9
    Last Post: 01-20-2011, 02:22 PM
  5. Selected items in listbox
    By tomodachi in forum Access
    Replies: 1
    Last Post: 09-09-2010, 01:14 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums