Code:
DoCmd.OpenReport "Single_Incident_Report", acViewPreview, , "[ID] =" & Me.ID
I used the code you recommended above. It gave me an error stating that ID could refer to more than one table in my select statement, so I changed it to what's shown below and it ended up working just fine... Thanks. I tried a million different ways for hours before finally being willing to post the question. I really preferred to use the Where property in the OpenReport command, but I had tried it a million ways earlier and it wasn't working.
Code:
DoCmd.OpenReport "Single_Incident_Report", acViewPreview, , "[Incidents].[ID] =" & Me.ID