I'm relatively new to Access and I've come unstuck.
I've put together a form where I can drill down into the academic interests of academics with key words. I'd like to be able to show the contents of interest_A, interest_b, and interest_C of the selected record/row in the Text15 text box at the bottom of the image and for that to change automatically if I selected another record/row.
If this is possible, then I might hide interest_A, interest_b, and interest_C from view of the user and just have them visible in Text15
Any help would be greatly appreciated.
I've looked around for advice or tutorials but haven't found anything on this issue.