Linking Subform1 to Subform2

[Perfac]

1. Main form is f02Journals, and the sub form is f02JournalsSub. Sub form 2 is f02SubAccountSub.
2. I am trying to add a second Sub form. I have a challenge linking Sub form 2 to Sub form 1.
3. In the image a field “Coment_IDh” can be seen in sub form 1.
4. Sub form 2 has a field in the query “Coment_IDs”, not displaying on Sub form 2.
5. On image 1 a text field can be seen that returns the ID in field “Coment_IDh” to the main form from Sub form 1.
6. I fail to get a “Master field” to connect to. Image 2.
7. I added a field “Coment_IDi” to table t02Journals. If an expression that can return the ID in “5” above to this field “Coment_IDi”, I believe it will work for what I want to do.

[Gicu]

Name the textbox control you mention in point #5 txtCommentID and enter that (manually) in the Master field.

Cheers,

[Micron]

The guiding principles can be found many places. Here's one that might help for future cases

https://www.fmsinc.com/microsoftacce...edSubforms.asp

[Perfac]

Thanks Vlad it worked. I thought I did it with the name that was there? I changed the name and now it works. I put a Me. in front of it.

[Gicu]