Results 1 to 4 of 4
  1. #1
    AML_Jamie is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    2

    I'm trying to have a display display value of TWO columns in ONE lookup field. (Table & Form)

    I have a table and form (Work Orders) that has a lookup field that references 2 columns (first name & last name) in a Customer Contacts table. In the form and table, the drop down displays both first and last name. When the value is chosen, only the first name is displayed. How can I display both first and last name in one lookup column for both the table and form?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Concatenate, like:

    SELECT ID, LastName & ", " & FirstName AS FullName FROM Customers;

    Adjust other combobox properties as appropriate.

    I NEVER set lookups in table. I prefer to see actual value in field when I view tables/queries.
    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.

  3. #3
    AML_Jamie is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    2
    Thanks June7.

    Also, I'm new to Access and learning everything through forums. I've read all over that lookups aren't recommended in tables, so I plan to convert all my lookup fields in my tables to just plain text. Is there an easy way to do this? Is it as simple as changing the data type to short text and display control as list or text box? I haven't tried it because I don't want to lose anything in my DB.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Why would you change to short text? If it is a number field and you still want to save numeric ID, then the type should remain number.

    Just change the control type to textbox on the Lookup tab.

    Test with copy of table.
    Last edited by June7; 10-28-2015 at 02:43 PM.
    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.

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

Similar Threads

  1. Lookup field display
    By LaughingBull in forum Access
    Replies: 7
    Last Post: 01-07-2017, 07:55 PM
  2. Display lookup value in form, not code.
    By lggerhard in forum Forms
    Replies: 2
    Last Post: 09-10-2014, 06:57 PM
  3. Inventory Form with Display Lookup
    By Kbiddle in forum Forms
    Replies: 1
    Last Post: 12-23-2011, 01:16 AM
  4. Replies: 6
    Last Post: 10-20-2011, 11:27 AM
  5. Report control of a field display/no display
    By systems013 in forum Reports
    Replies: 5
    Last Post: 02-01-2010, 09:44 AM

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
  •  
Other Forums: Microsoft Office Forums