I have a form which utilizes a subform (continuous). I want to copy the information in the current fields into a new record. I am using a the following VBA to copy the information on the primary form and it is working just fine (thanks Linq).
Private Sub cmdCpy_Click()
Dim cboSpplr As String
Dim cboItmNmbr As String
'Copy fields to variables
cboSpplr = Me.cboSpplr
cboItmNmbr = Me.cboItmNmbr
'Go to a new record
DoCmd.GoToRecord , , acNewRec
'Reverse the process and plug old values into new record
Me.cboSpplr = cboSpplr
Me.cboItmNmbr = cboItmNmbr
End Sub
However, there is information I want copied over from the subform. What would the VBA look like?
Subform name: frmFAI02
Filed name: cboCrts