Multiple copies of a form open at once

B

Bob 4

I have a reservation planning and management system used several
reservationists. They use the tour planning form throughout every day. They
are interrupted several times an hour to answer questions from customers
calling on the phone. They are finding it inconvenient to stop work on the
current tour, then search for it and return to it later.

Is there a way to have two (maybe three) copies of the tour planning form
open at the same time.

Thanks. bob
 
M

Marshall Barton

Bob said:
I have a reservation planning and management system used several
reservationists. They use the tour planning form throughout every day. They
are interrupted several times an hour to answer questions from customers
calling on the phone. They are finding it inconvenient to stop work on the
current tour, then search for it and return to it later.

Is there a way to have two (maybe three) copies of the tour planning form
open at the same time.


Yes there is, but it's definitely an advanced topic. The
way to open a form that way is to use something like:
Set frm = NEW Form_formname

But the complexity come from the fact that you have to keep
your own collection of the open instances instead of using
the Forms collection. You also need to remove the reference
from your collection when the user closes the form (or
instead of using DoCmd.Close)

There's an excellent article on this topic at:
http://allenbrowne.com/ser-35.html
 
Top