I personally have not see any examples of this, but I have a feeling It can be done, I just don't know how. I am a access amateur. I built this DB and have a subform with info from another table. It filters on CityName, and displays all records in a table format like shown in the pic attached. I would like to add a text box that will show a specific field in the record based on the record that is currently selected.
So in the example, I need to know how to set the properties of the text box, so when I select the record Timmet Steele, in the subform, the text box to the right displays the text in the Notes field from that table for the record Timmet Steele.
Any help would be greatly appreciated.