***Resolved*** SetFocus problem

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

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.

Use something like this :

VB Code:

' 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...

try this lines:
load form1
form1.show

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



Vince

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