Opening Report when Access is opened

  • Thread starter Thread starter Drew
  • Start date Start date
D

Drew

Is it possible to open a report instead of a form when access starts? I
have made a blank form, but it seems to get in the way.

Thanks,
Drew
 
Drew

Access will automatically run a macro named Autoexec (if I recall
correctly), so you could create one with that name to do what you want.

Another approach would be to use the Startup option from the Tools menu, and
select the form you wish to open on startup. That form could remain hidden,
but run whatever code you wanted to initialize your application.
 
Ok, I have an empty form named ELP, and this empty form opens a report on
the on Open event. This report opens a form for data entry and then takes
this data to build the report. My problem is that I set ELP forms visible
to false and it doesn't show up. But when I enter the data for the report
and click Generate Report, the report opens but so does the empty ELP form.

I have tried setting the ELP form's visible property to false on the report,
but that doesn't help either.

Any ideas?

Thanks,
Drew Laing
 
Drew

Without a look at the code you're using, I'm at something of a loss to guess
how that might be happening. If the only purpose of the ELP form is to
start your report, why don't you just open the "data entry" form first?
 
Back
Top