I have a form frmCompanies on which a record ComID is selected.
Then I open a form frmNotes with a macro filtering all notes in tblNotes where ComID = frmCompanies.[ComID].Value.
Now when I decide to make a new note, I want the frmNotes.[ComID].Value must also be set equal to frmCompanies.[ComID].Value.
I was thinking to use On Dirty as trigger to achieve this. However I don't find a way to allocate a value of a control from another form to a control on the active form.
I do not want to use a subform.
I do not have experience with macros, so this is the first one. I know VBA.
Any help please.