Just set the change method
Private Sub RefEdit1_Change()
RefEdit2.SetFocus
End Sub
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"JT" wrote:

I have 3 RefEdits on a form. The user will select a different cell for each
RefEdit.

Currently the user has to select each RefEdit to select a cell.

Is there a way to automatically tab to the next RefEdit control once the
user selects a cell?

The tabs are set up correctly, so that when the form is opened, I can tab
through the controls in the correct order.

Any help would be greatly appreciated.....Thanks
--
JT