text box that shows data form selected subform record

[noretoc]

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.

[pbaldy]

How about:

http://www.baldyweb.com/Autofill.htm

[noretoc]

How about:

http://www.baldyweb.com/Autofill.htm

Afraid not, that is looking at it as two levels. IT works fine to display the info from the main form, btu not the sub form.
So the Main form is pulling in a record from table a (City). The sub form is pulling in info from table b (people). It is filtering table b to show only records which match the record in table A that the form is on.
Thet is a one to many relationship though. I need a way to tell the box that I al looking for information from table b(people) but filtered not by the record from table A the main form is on, but by the selection from table B that is highlighted in in the subform.

I thought about using a "onclick" even on the subform but I don't know how to make the event tell the text box to show specific information.

[pbaldy]

Can you attach the db here? I'm not visualizing the setup.

[ArviLaanemets]

You can have a look at form fMain2 in AssesmentObjetivesxample.accdb in zip-file I attached to post# 22 at

https://www.accessforums.net/showthr...t=78941&page=2

[davegri]

The textbox in question is actually on the main form, not on the subform. Let's call it txtNotes. I assume Notes is a field in the subform's recordsource.

So in the subform's on_current event:

Me.Parent.txtNotes = [Notes]

Clicking on different rows in the subform will fire the current event.

[noretoc]

The textbox in question is actually on the main form, not on the subform. Let's call it txtNotes. I assume Notes is a field in the subform's recordsource.

So in the subform's on_current event:

Me.Parent.txtNotes = [Notes]

Clicking on different rows in the subform will fire the current event.

You got it. This is more along the lines of what I was thinking but had no idea how to code it. I was sure it was something simple though. This solves a lot of different issues. I love you in a non-committal non-gender assuming purely platonic way. Thank you very much!