2nd Attempt: Instance of form does not have focus

[Terry Holland]

Subject: Instance of form does not have focus
From: "Terry Holland" <[email protected]>
Newsgroups: microsoft.public.access.forms

From one of my forms I need the user to be able to open a
number of instances of frmSupplier. The code that im
using to open instances of frmSupplier is essentially
this :

Dim frmSupplier As Form_frmSupplier
Set frmSupplier = New Form_frmSupplier

With frmSupplier
.Visible = True

While .Visible
DoEvents
Wend
End With


This worked fine in Access 97 but in 2000 (&2002) the new
instance of the form does not have the focus when it
becomes visible.

I have tried setting popup to true but this doesnt work.
I cant set modal (though when I have it doesnt work) as I
need more than one instance open at a time.

How can I accomplish the following?

get one form (frmParent) to open many (as many as user
wants) instances of another form?
I need to be able to interact with the public properties &
functions of frmSupplier from within frmParent
I need the instance of frmSupplier to have the focus when
it opens. (at the moment the focus remains with frmParent)

tia

Terry Holland