Tab to next field after checkbox clicked

[janbrown56]

I have a form that where users will select the parts that they need labels for. There are lines of available parts to select from and a checkbox for them to click on to select their parts. If a part is selected then a carton quantity field must be entered. I set validation rules on the table to make sure that both are done but I would like to automatically put the focus in the carton quantity field after they select a part. I have not been able to figure out how to do this. I know it would be some event OnClick but I don't know how to set it up. All the fields are locked except for the checkbox and the carton quantity field. I have set the tab order so the checkbox is the first tab field and the carton quantity is the next field.



Do you have any suggestions?

Thank you for your time.

Jan Schmitt

[pbaldy]

Try the after update event of the checkbox, using SetFocus.

[Missinglinq]

Something like this, substituting your actual Control names:

Private Sub CheckboxName_AfterUpdate()
 If Me.CheckboxName = -1 Then
  Me.CartonQuantityTextbox.SetFocus
 End If
End Sub

If the user ticks the Checkbox, realizes a mistake has been made, and unticks it, the Focus will not go to the Carton Quantity Textbox.

Linq ;0)>

[trevor40]

In the form design you can set the TAB order tbe whatever you need.

no code required.

[pbaldy]

In the form design you can set the TAB order tbe whatever you need.

no code required.

Clicking on a checkbox will not trigger this.

[Demerit]

You can only do that with a macro or with VBA but i recomend VBA. Just as explained by Missinglinq