frmSOP display information on SOPs that staff must be trained on
frmEvent is used to schedule training events for specific SOPs
User clicks "Schedule Event" button on frmSOP and frmEvent should open to a new record with the title of the Event prepopulated with the SOP name of the parent form.
The On_Click event for the frmSOP "Schedule Event" button is:
DoCmd.OpenForm "frmEvent", acNormal, , , acFormAdd
The Form_Load event for the frmEvent is:
Me.TrnId = Forms!frmSOP.TrnId
I get a message "You can't assign a value to this object"