Coding in Forms

[Guest]

I am trying to set up coding within a form so that when an option is selected
from a control, the cursor will jump to another control within the same form.

As an example, i have a control box which features a drop down list. If a
particular option within the drop down list is selected by the user, I want
the cursor to jump to another control box. Ideally if its possible to create
a pop up with a message then that would good enough,

Thanks,
Wasim

 

[Guest]

The code recommended below works fine however works if any option within the
drop down list is selected. I need coding which I can use so if a say for
example 'Complaint' is chosen from the drop down list, the cursor goes to the
complaints field, or if 'Mailing' is selected from the same drop down list,
the cursor goes to the mailing field.

Thanks..

On the OnChange event of the ComboBox you can add the code to set the focus
to another field

Private Sub ComboName_Change()
Me.[FieldName].SetFocus
End Sub

--
\\// Live Long and Prosper \\//
BS"D

I am trying to set up coding within a form so that when an option is selected
from a control, the cursor will jump to another control within the same form.

As an example, i have a control box which features a drop down list. If a
particular option within the drop down list is selected by the user, I want
the cursor to jump to another control box. Ideally if its possible to create
a pop up with a message then that would good enough,

Thanks,
Wasim