Is it possible to control the navigation between the various entities in a form .. for eg I have

Combobox 1
Textbox 2
Combobox 3

If value of "combobox 1" is say 2 then go to "textbox 2" or else go to combobox 3..

Thnx in advance

Welcome to Utter Access Forums!

In the After Update event of Combobox1:

If Me.ComboBox1 = 2 Then
Me.TextBox2.SetFocus
Else
Me.ComboBox3.SetFocus
End If

hth,
Jack

thnx jack,, It is working if I give ... Me.combobox=1 then..

But when I use an OR control is not going where I want.. Am i missing something.. ??

This is my code.

If Me.Combo18 = 1 Or 2 Then
Me.Combo22.SetFocus
Else
Me.Combo20.SetFocus
End If

This will work:

If Me.Combo18 = 1 Or Me.Combo18 = 2 Then
Me.Combo22.SetFocus
Else
Me.Combo20.SetFocus
End If

Jack

Thnx a bunch

You are welcome...

Jack