T
TravelingHT
Dear All:
I have a form with a subform, I want on the choice of "Yes", in the Combo
Box, for the tab order to change to a txt box in the sub form of the current
form.
I am often confused by two points. (And possiably more, the unknown unkonwn,
but lets leave that one to that Dick Chany. )
1. If I am puting code at the form level, then I should be using the
responses, i.e.
"Yes" Instead of "-1" and "No" instead of "0" ?
2. Should I be referencing the "Value" of the control or something else?
This is the code I currently have which is not working.
Private Sub EverHiredTemporaryHistologist_Exit(Cancel As Integer)
If Me.EverHiredTemporaryHistologists.Value = 0 Then
DoCmd.GoToControl (Me.RoleINHiringDecision)
ElseIf Me.EverHiredTemporaryHistologists.Value = -1 Then
DoCmd.GoToControl (Form!sbfrmTempHTMostImportant.LabManagerResponse)
End If
End Sub
Thanks in advance
Traveling Tech
I have a form with a subform, I want on the choice of "Yes", in the Combo
Box, for the tab order to change to a txt box in the sub form of the current
form.
I am often confused by two points. (And possiably more, the unknown unkonwn,
but lets leave that one to that Dick Chany. )
1. If I am puting code at the form level, then I should be using the
responses, i.e.
"Yes" Instead of "-1" and "No" instead of "0" ?
2. Should I be referencing the "Value" of the control or something else?
This is the code I currently have which is not working.
Private Sub EverHiredTemporaryHistologist_Exit(Cancel As Integer)
If Me.EverHiredTemporaryHistologists.Value = 0 Then
DoCmd.GoToControl (Me.RoleINHiringDecision)
ElseIf Me.EverHiredTemporaryHistologists.Value = -1 Then
DoCmd.GoToControl (Form!sbfrmTempHTMostImportant.LabManagerResponse)
End If
End Sub
Thanks in advance
Traveling Tech