I am trying to open a Form from a report that will allow you to add another incident onto the same record. This requires the new form when it opens to have some but not all of the new fields to be auto populated so that the ID is the same and they all stay linked. My open arguments don't seem to be working though I copied them DIRECTLY from Microsofts example and changed the name. The form opens but nothing populates. Here is what I've tried so far.
Private Sub Command19_Click()
DoCmd.OpenForm "IncidentDetails", acNormal, , , acFormAdd, acWindowNormal, _
EventID = Reports!IncidentFocus!EventID
End Sub
I've also tried:
Private Sub Command19_Click()
DoCmd.OpenForm "IncidentDetails", acNormal, , , acFormAdd, acWindowNormal, _
"EventID =" & [Reports]![IncidentFocus]![EventID]
End Sub
I've tried a few others but they aren't even worth mentioning. Please Help!