I'm using this command to pass fields "case number" and "victim id" to "additional victim" form from "clients" form, I need to pass 2 more fields from clients: "accepted services date" and "accepted service". What would be the correct syntax ?
Private Sub Add_Add_Victim_Click()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Set myfrm = Screen.ActiveForm
DoCmd.OpenForm "additional Victim", , , "[case number]=forms!client!casenumber and victim=2"
End Sub
Private Sub Add_Add_Victim_Click()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Set myfrm = Screen.ActiveForm
DoCmd.OpenForm "additional Victim", , , "[case number]=forms!client!casenumber and victim=2"
End Sub