I have created a database that my department uses at work, and I am making some modifications. But there is one report I can't get to pull up like I want.

This is what i have for the Visual basics code:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "Status Update", acViewPreview, , ("[CallID] =" & [CallID])

The Call ID is the date of the note we are sending an email on, but we need it for the same policy number (which that part is working) and only the last entry for SS Requirements on that policy number, currently the report creates a page for each entry of the SS requirements.

Here is a copy of the table relationships.
https://cdn.geekzone.co.nz/imagessubs/blog046539dff2be062a6ced581888fac2ef.jpg