How to open multiple forms on startup?

L

Lunchguy

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
 
D

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".
 
B

boblarson

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.
 
Top