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.