antonyx
Arsenal Supporter
- Local time
- Today, 11:25
- Joined
- Jan 7, 2005
- Messages
- 556
Code:
Private Sub idfound_KeyDown(KeyCode As Integer, Shift As Integer)
Dim idme
idme = idfound.Text
If KeyCode = 9 Then
If IsNull(idfound) Then
Me.personname.SetFocus Else
Forms!Job.qbook.Value = idme
DoCmd.Close
End If
End If
End Sub
basically if the user tabs from the field (keycode 9) and the field is empty.. focus on another field.. if it is not empty then send the value to another form and close the current form...
how should i use two if statements like this.