***Resolved*** SetFocus problem

[Franky]

Hi everybody,

I use many times Private Sub Form_Load to set some parameters in the Form before the use use it. But I need to set on Fields .SetFocus to start with the correct textfield. Unfortunatly it seems that with Form_Load are the controls are still not loaded. How can I set at Form-start any SetFocus that I want?

In Access exist a Sub that can be called AFTER the form is loaded. I didn't find this in VB.

Any idea how to set the SetFocus?


Franky

[zemp]

Use the form activate event. When a form is load the load event fires and then the activate event fires when the form becomes the active form.

[James Stanich]

Use something like this :

' In Form Load
 
' Additional Code
 
Me.Show
 
Text1.SetFocus

Problem is you cannot set focus to a control that has not been visually "seen" yet...

[JosephNUy]

try this lines:
load form1
form1.show

[Ecniv]

Or look at your tab order and the text field you want to start in set to 0....



Vince

[Franky]

Nice ideas from all of you. But the best is of course the

Private Sub Form_Activate()


It was the sub that i was looking for.


Thanks again

Franky