My mother form has a comments form which links to the tblComments.
The mother form also has a control that opens a daughter form which also has a similar comments form on it.
Presently when I make a comment while on the mother form and then navigate to the daughter form, the same comment that was active on the mother form is still active.
The same is the case if I make a comment on the daughter form and navigate to the mother form.
I want that each time the mother form opens, the comments form must open in a new record and vice versa.
I attach my database.
It opens on form "Process WIP Vessel Documentation". The comments form is at the bottom.
When you click on "General Information" control, the general Information form opens. The comments form is at the bottom. db2.mdb