enabling next control..

[keybearer]

hi.. a little help please.. on my form theres a textbox named profession.. and the next texbox named rank.. the rank txtbox is disabled..
how do i automatically enable the rank txtbox and set the focus on it when the profession entered is equal to "army officer" and just go to the next txtbox if the value is not..

 

[Mile-O]

Use the After Update event of the Profession control.

i.e.

If Me.cboProfession = "Army Officer" Then
    With Me.cboRank
        . Enabled = True
        .SetFocus
    End With
Else
    Me.cboRank.Enabled = False
    Me.NextControl.SetFocus
End If

 

[Mile-O]

Just a sly suggestion in there that you should use a combo box rather than a textbox to collect professions...

 

[keybearer]

hey.. thanks for the help.. about your suggestion, i dont think its possible because sometimes a person may have more than one profession..
anyways.. thanks again...

 

[Pat Hartman]

If they can have more than one profession, then your data structure is incorrect. You should NOT be storing multiple values in a single field.