is it possible to change Report_Open to something that opens a que

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I have this to open a report up

Public Sub Report_Open(Cancel As Integer)

is there a way i can change this so it open a query table instead ??
 
???????

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.
 
Alan said:
I have this to open a report up

Public Sub Report_Open(Cancel As Integer)

is there a way i can change this so it open a query table instead ??
Click to expand...

What is your over all objective? What is the problem you are working
on?

Tony

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Back
Top