form focus

[smk23]

I have a form that is loaded but invisible until called. When I make the form
visible, I would like to run some code. If "frm" is set as the form being
called, I have these lines:

frm.Visible = True
frm.SetFocus

I tried putting the code on the "Got Focus" event of frm with no results.
Where should I put the code that needs to run every time the form is visible?
Thanks!!

 

[Marshall Barton]

I have a form that is loaded but invisible until called. When I make the form
visible, I would like to run some code. If "frm" is set as the form being
called, I have these lines:

frm.Visible = True
frm.SetFocus

I tried putting the code on the "Got Focus" event of frm with no results.
Where should I put the code that needs to run every time the form is visible?

How about putting all your visible process into a public sub
procedure in the form's module:

Public Sub DoVisible()
Me.Visible = True
' all the other stuff you want to do
. . .
EndSub

Then you could call it from anywhere using:

frm.DoVisible

 

[Linq Adams via AccessMonster.com]

The reason, from Access Help:
If a form contains controls for which the Enabled property is set to True,
you can't move the focus to the form itself. You can only move the focus to
controls on the form. In this case, if you try to use SetFocus to move the
focus to a form, the focus is set to the control on the form that last
received the focus.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Stuart McCall]

I have a form that is loaded but invisible until called. When I make the
form
visible, I would like to run some code. If "frm" is set as the form being
called, I have these lines:

frm.Visible = True
frm.SetFocus

I tried putting the code on the "Got Focus" event of frm with no results.
Where should I put the code that needs to run every time the form is
visible?
Thanks!!

I think you ought to be able to use the form's Activate event.

 

[geppo]

I have a form that is loaded but invisible until called. When I make
the form visible, I would like to run some code. If "frm" is set as
the form being called, I have these lines:

frm.Visible = True
frm.SetFocus

I tried putting the code on the "Got Focus" event of frm with no
results. Where should I put the code that needs to run every time the
form is visible? Thanks!!

qui:

private sub form_activate()

..........................
.....................
.....................

end sub

 

[Marshall Barton]

The reason, from Access Help:
If a form contains controls for which the Enabled property is set to True,
you can't move the focus to the form itself. You can only move the focus to
controls on the form. In this case, if you try to use SetFocus to move the
focus to a form, the focus is set to the control on the form that last
received the focus.

True, but irrelevant.

If there is an enabled control, setting the focus to the
form will set it to the active control in any case. Either
way the form is visible and active.