Simple Q

[Mutiny]

I am using Access I would like to know if there is a method that you can use to initialise the form controls

.......

So basically I am after a method that will automatically run as soon as the user opens the form, then that method can initialise things like control default values and combo box list items. (I know that both of those can be done other ways but I would like to do them in VBA)

[alex_read]

Private Sub Form_Open(Cancel As Integer)
    Forms!MyFormNameHere!Text1.SetFocus
    Text1.Text = "Hello world"
    
    MsgBox "Done setting form control values, " & _
    "now showing the form to the user..."
End Sub

[Mutiny]

thanx alot for your speedy reply!