Instance of form does not have focus

T

Terry Holland

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2nd Attempt: Instance of form does not have focus 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Word macro that can call cells out of Excel for a find and replace 0
Pop Up Form Focus Question 1
Pop Up Form Focus Question 1
Pop Up Form Focus Question 2
Pop Up Form Focus Question 3
Multiple Instances of a Form, ....one too many.... 2

Top