Setfocus event

[Quique79]

Hi!!

I'm designing a form, and in a textbox on lostfocus event I wrote this:

if Text27.text = "" then
Msbox "Data Needed"
Text27.setfocus
End if

Message works ok, but I got an error that I cannot establish a control property at least that the control has focus

What can I do?

Any tip or hint??? Quique79

 

[jebry]

Hi Quique79!

Try this in the BeforeUpdate event:

If Nz(Len(Text27.Text), 0) = 0 Then
YourMessageHere
Cancel = -1
End If

hth
Jeff Bridgham
bridgham@purdue.edu