Thanks for the reply!

I actually was able to fix it with some simple steps! To fill in the parameter prompts, I did the following:

DoCmd.OpenQuery "qryNPSbyCity"

[City] = Me.City
[StartDate] = Me.StartDate
[EndDate] = Me.EndDate


and to fill in the value from the query to the form, I used:

Me.NPS.Value = DLookup("NPS", "qryNPSbyCity")

Then I added:

DoCmd.Close acQuery, "qryNPSbyCity"

to remove the open query from the screen.

Pretty exciting!