???????
Your question, at least as posted, doesn't really make sense.
This line;
Public Sub Report_Open(Cancel As Integer)
is the beginning line of the Report_Open event. This event does not
"open" the report. It is merely a procedure where you *could* put
some code to make something specific happen when the report opens
(the report would actually be opened by some other method).
However, you seem to be saying that you don't want to open a
report, but rather a table or query (I think?).
You'll need to post some more details for anyone to be able
to help you.