set Focus back to current text box

[kronar]

I can't seem to find how to reset the tab order or focus back to the same text box after I detect entry in error. I am seting textbox value to null and then want the cursor to be set back to that text box after user clicks OK on the msgbox warning record not found.
I am sure I used to be able to do this, but can't find any example or description in any of my books or help files.
I find VB with Access97 so frustrating trying to find any information - is this really so hard??

 

[TheAceMan1]

How are ya kronar . . .

Use the [blue]Before Update[/blue] event of the control and set the [blue]Cancel[/blue] to true if your validation fails . . .

[blue]   If Trim(Me!TextboxName & "") = "" then
      [purple][b]Cancel[/b][/purple] = True
   End If[/blue]

[blue]Focus stays in the control! . . .[/blue]

See Ya! . . . . . .

 

[kronar]

Worked, Thanks