I have a form called frmContacts that uses contact_ID set to AutoNumber as the Primary Index. This form has a subform called sfrmContactNotes in Datasheet View that I have set to NoEdits, Deletions or Additions. I put a CmdButton, Enter New Note, at the bottom that opens a form where you can type your new note.
How do I get the contact_ID from the frmContacts form to be entered in the field on the tblContactNotes. If I did it directly in the subform it does automatically due to Lnk Master/Child Fields.
I have tried setting the default value to accomplish this. I have also tried Me![contact_ID] = Forms!frmContacts!contact_ID
Nothing Works. Please help.
How do I get the contact_ID from the frmContacts form to be entered in the field on the tblContactNotes. If I did it directly in the subform it does automatically due to Lnk Master/Child Fields.
I have tried setting the default value to accomplish this. I have also tried Me![contact_ID] = Forms!frmContacts!contact_ID
Nothing Works. Please help.