I want to create a button that will create a new record for data-entry. However, one of the fields in the new record will take a value from a field of the current record. My attempt —
Private Sub NextCondition_Click() DoCmd.RunCommand acCmdSaveRecord DoCmd.GoToRecord , , acNewRec If Me.NewRecord Then Me.RespondentID = FormID End If End Sub
FormID is the variable wherein I stored the OpenArgs (which contains the RespondentID). Basically, when this button is clicked, I want the following to happen: save the current record, open a new record, set the respondentID field to the prior records respondentID. However, in my current implementation (i.e. using this code), the new record has a respondentID of 0.