OK, I think I figured out a way to make this work, it may be clunky but it does the job. I would prefer if the report never opened and just closed if someone knows a better solution let me know.
Private Sub Command14_Click()
DoCmd.OpenReport "Labels Table1", acViewPreview, acHidden, "[ID]=" &...