set focus to control on sub form

[mbair]

I have a textbox on a subform. After I run the afterupdate
event on the textbox I want to set focus to that same textbox if the textbox is null.

 

[ThomasLafferty]

Hi mbair!
If you want to force the user to enter a value in the textbox (if it is bound) set its required property to Yes in the table design and the user will not be allowed to leave the form without completing it.

Also, use code like this in the [!]BeforeUpdate[/!] event of the control to disallow the null and force data entry:

[COLOR=blue]Private Sub[/color] myTextbox_BeforeUpdate()
     [COLOR=blue]If[/color] IsNull(Me.myTextbox.Value) = [COLOR=blue]True Then[/color]
          Cancel = [COLOR=blue]True
     End If
End Sub[/color]

Born once die twice; born twice die once.