You need to look at the master/child properties of the subform control.
navigation form:
-cons. it stays unlinked so when main form changes records - the attached form stays the same. like there is not parent \ child connection.
-pros. it has button so i can switch between 6-7 forms
subform\subreport:
-cons. it has spreadsheet style and all data of 1 records = 1 row. its not userfriendly and i simple can't see even 20% of all information i need. so much space are wasted.
-pros. it has parent\chiled connections. when mainform's records changing, this subform shows me every recorded which is linked as in relationship
just adding subform (i mean i created a form and put there all data from non-main form)
-cons. it stays unlinked so when main form changes records - the attached form stays the same. like there is not parent \ child connection.
and i dont know how to switch between 6-7 forms using some buttoms.
pros. no pros for me.
so im having hard time to make some kinda form so it switches between eachothers by clicking some buttons.
the good advice for me was to link forms in the navigation form to main form records, but i simple dont know how to do it exactly.
as i get it , i need to make linked ID in subform follows the main form record (parent record) how to do it ? where ? on lick event? on load ? selecting whole subform or just that ID linked to parent form ?