previous field

[Bre-x]

Hi,
I have this function on a datasheet form.
It doesnt work. After i click Ok, the focus doesnt stay with the RQTY
field, it actually moves to the next record.
Is there something like go back to last focus?

Private Sub RQTY_LostFocus()
If Me.R = -1 Then 'Yes we want to ship this line
MsgBox ("Must Enter Qty other thant '0'")
Me.RQTY.SetFocus
If Me.RQTY = 0 Then
Me.RQTY.SetFocus
Else
End If
Else
End If
End Sub

 

[B. Comrie]

In the form properties set the Cycle Records Property to Current Record.

B Comrie
http://www.codewidgets.com