Hello everyone,
I'll try to be as clear as possible.
I have two subforms attached to a form. The first one contains many fields, one of which is called "notes". The second subform is just made up of one field by the same name ("notes"
.
The first subform only shows a small section of the data in the "notes". So what I want is to have the second subform show all of the data in the "notes" field when the correspronding field (cell) is clicked in the first subform.
It looks like I have them linked together properly. When I Scroll through Subform 2 manually, it corresponds with the "Notes" field in the First Subform. It is just the automatic updating (filter?) that I need.
If it makes any difference, Subform One is in Datasheet view.
Thank you very much,
Matt
I'll try to be as clear as possible.
I have two subforms attached to a form. The first one contains many fields, one of which is called "notes". The second subform is just made up of one field by the same name ("notes"
. The first subform only shows a small section of the data in the "notes". So what I want is to have the second subform show all of the data in the "notes" field when the correspronding field (cell) is clicked in the first subform.
It looks like I have them linked together properly. When I Scroll through Subform 2 manually, it corresponds with the "Notes" field in the First Subform. It is just the automatic updating (filter?) that I need.
If it makes any difference, Subform One is in Datasheet view.
Thank you very much,
Matt
