I have finished a project and I am trying to clean it up. I have a query that runs from a n action button on a form, outputting the results to a report. Is it possible to have the query run quietly in the background, without prompting to overwrite and add records. Just steer me in the right direction. Thanks

Not clear why your query is overwriting/adding records if it's just dumping information to a report, BUT:
Look into DoCmd.SetWarnings False/True.
Remember to set them True again afterward or you will get no further warnings, error messages, etc.

HTH,
David R