I have a form (frm_1) that has an event if the txtbox value equals "no", then it opens another form (frm_2) on new record.
frm_2 opens on a new record but I would like the Program Name value in frm_1 to be copied into the Program Name field in the new record in frm_2. I've tried the code below but I can't get it to work. The only time frm_2 will open will be from the frm_1.
Code:
Private Sub txtYesNo_AfterUpdate()
If Me.txtYesNo.Value = "no" Then
DoCmd.OpenForm "LatePR_frm", , , , acFormAdd
End If
End Sub
frm_2 opens on a new record but I would like the Program Name value in frm_1 to be copied into the Program Name field in the new record in frm_2. I've tried the code below but I can't get it to work. The only time frm_2 will open will be from the frm_1.
Code:
Private Sub Form_Open(Cancel As Integer)
If Me.NewRecord Then
Me.txtProgramName = Form([PR_Reporting_frm]).[txtProgramName]
End If
End Sub