How to open multiple forms on startup?

[Guest]

Hi

Is there a way to have 3 'forms' open automatically on startup?

I've found out how to get a single form to open when the database file is
open but it would make my life easier if there were 3.

Also, is there a way (other than print screen) to print the data just
entered into the form? Or will I need to create a report template? The reason
I ask is that I would like people to print the form to keep a paper record on
file.

Thank you

 

[Douglas J. Steele]

1. You can either create a macro named AutoExec that calls three separate
OpenForm actions, or you can put two OpenForm method calls in the Load event
of the one form that's currently opening.

2. Not really. Forms are meant for data entry, reports are meant for
printing. Note, though, that Access will convert a form into a report for
you. Just right-click on the form in the list and choose "Save As Report".

 

[Guest]

To open more than one form on open you can do it any number of ways, but the
easiest is probably to create an AutoExec macro and just use 3 actions to
open a form from each.

If you have a macro named AutoExec, it will fire when the database opens as
the first thing.

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Guest]

Thanks Douglas and bob. Very much appreciated.
Have set up the macro now.

Cheers

 

[David Shannon]

I have an Access 2007 application with three forms. I am trying to get them all to open in the AUTOEXEC macro, but only two are opening. Any help would be appreciated.

 

[dstrong]

I'm trying to open multiple forms concurrently with the same filter criteria. ie only have to enter an identifying number once, and multiple forms open for that identity. I tried creating a macro with multiple form opening commands, but couldn't find a way of saying "filter on the SAME id number as previously entered for the other form/s"
All suggestions welcome. Thanks very much. David