Results 1 to 2 of 2
  1. 12-14-2011, 02:06 PM #1
    tylerg11
    tylerg11 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    200

    Stored vs. Displayed Data for a ComboBox


    I have a ComboBox (or lookup field), that is storing employee information. I want it to store the employee number, but the dropdown contains the employee name. I know this is doable, and you can accomplish this through the wizard. But I am trying to relink the data for the lookup field, so I'm not using the wizard. How can I view the lookup field properties, so I can view/change how and what data is stored, and what is displayed??
    Reply With Quote Reply With Quote
  2. 12-14-2011, 03:11 PM #2
    alansidman's Avatar
    alansidman
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    This link should help you.

    http://www.techonthenet.com/access/comboboxes/index.php
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Where is check box data stored?
    By JeffG3209 in forum Forms
    Replies: 3
    Last Post: 09-09-2011, 11:23 PM
  2. Can Data be Stored in a Report
    By jgross in forum Reports
    Replies: 1
    Last Post: 02-02-2011, 10:31 PM
  3. Change database where data is stored with a dropdown box
    By le_carrington in forum Programming
    Replies: 5
    Last Post: 11-25-2010, 11:45 PM
  4. record selected in SUbform data to be displayed on main form
    By mrbabji in forum Access
    Replies: 1
    Last Post: 10-13-2010, 12:40 PM
  5. Problem with getting data displayed in report
    By ds_8805 in forum Forms
    Replies: 0
    Last Post: 03-24-2010, 12:51 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums