Results 1 to 3 of 3
  1. #1
    CaveCanem is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    9

    Select record in a listbox to display memo field from that record in unbound text box

    I'm trying out a concept in a "sandbox" database (attached) so that I can use it in a larger, more complex database later. Specifically, I have built a search form that allows the user to enter a text string into an unbound text box. A listbox on the form displays several fields from records that match the search criteria.



    I would like for a textbox below the listbox to display a memo field from the record that is highlighted in the listbox. That way, as the user selects and then scrolls through matching records in the listbox, they can see the contents of the memo field for each record (since memo fields don't display in listboxes, apparently).

    Any help you can give me is greatly appreciated.
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Expression in textbox ControlSource:

    =DLookUp("Narrative","InitialContact","ID=" & [SearchResults])
    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
    CaveCanem is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    9
    Worked like a charm. Thanks!

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

Similar Threads

  1. Select a record and display an image
    By Chris G in forum Forms
    Replies: 5
    Last Post: 11-01-2012, 04:38 PM
  2. Display record in unbound text field on form
    By MAABDOLAT in forum Forms
    Replies: 1
    Last Post: 07-25-2012, 06:10 PM
  3. Replies: 2
    Last Post: 06-05-2012, 12:33 PM
  4. Replies: 5
    Last Post: 08-29-2011, 05:17 PM
  5. Replies: 9
    Last Post: 07-21-2006, 05:17 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