By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,630 Members | 1,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,630 IT Pros & Developers. It's quick & easy.

ACCESS combo box field how can i use setfocus with in the lostfocuse property

P: 4
hi sir,
in access 2003 how we can use the setfocuse property(we have to lostfocuse from one field with in that we have to setfocuse in same field)
i am using this code but not setfocuse to same field :-

Description about this code:-

Sex field is one combo box in two options male-1;female-2
IND_APPL is one combo box here options are applicable-1;not applicable-0

CODE:-

Private Sub IND_APPL_LostFocus()
If Sex.Value = 1 And IND_APPL.Value = 0 Then
Form_PHMRC.SIB1.SetFocus
IND_Line.SetFocus
Else
If Sex.Value = 2 And IND_APPL.Value = 1 Then
IND_N20.SetFocus
Else
MsgBox ("CHECK WITH SEX")
IND_APPL.SetFocus
End If
End If
End Sub

here every thing ok but this statement IND_APPL.setfocuse not respond properley
while giving this options Sex.value = 1 and IND_APPL.value = 1 and
Sex.value = 2 and IND_APPL.value = 0 (ELSE block)
it show msgbox CHECK WITH SEX properely
but it is not setfocus to IND_APPL this field (it is setfocuse to next field)

please send me answer.
Mar 26 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.