title: MS Access Error '2110' Can't move the focus to the control
body: <p>I'm a beginner using MS Access 2016.
  I have a save button on a form that does some last minute input validation that is meant to be very direct and helpful to the end-user. I'm using a series of textboxes to step through the validation when they click the save button, this way they can complete then entire form and if there is an error it takes them directly to that field with the error. </p>
  
  <p>My code appears to work, 
  it detects an error, 
  sets the focus to the text179, 
  sees there is an error in the JobNo field, 
  gives a message saying "Please enter a 5 digit job number"and 
  sets the focus to JobNo. 
  Then and only then, do I get a second prompt saying there is an error. 
  But why is it saying it can't set the focus to text179 when it clearly already has done so and should no longer be trying at that point?</p>
  
  <p>Here is my code:
  <code>Private Sub SaveRecord_GotFocus()
      If Me.JobNo &amp; "" Like "#####" And Me.ItemNo &amp; "" &lt;&gt; "" Then
          Exit Sub
          Else
          Me.Text179.SetFocus
      End If
  End Sub
  Private Sub Text179_GotFocus()
      If Me.JobNo &amp; "" Like "#####" Then
          Me.Text181.SetFocus
          Exit Sub
          Else
          MsgBox "Please enter a 5 digit Job Number", vbOKOnly
          Cancel = True
          Me.JobNo.SetFocus
          Exit Sub
      End If
  End Sub</code></p>
  
  <p>Error:
  Run-time error '2110':
  Microsoft Access can't move the focus to the control Text179.</p>
  
  <p>Let me know if any additional information is needed.</p>