title: Trigger an event while navigating to next record
body: <p>I need to set the record source of a particular dropdown in a form based on the current record i.e when I click the next record, the record source should get updated.</p>
  
  <p>But I'm unable to find any event for doing so. This needs to be done without adding any extra/new buttons.</p>
  
  <p>I tried using the "Form Current" event but apparently it gets triggered only once when the form is loaded, and not when I move to the next record within the same form.</p>
  
  <p>Any suggestions?</p>
  
  <p>Sample Code:</p>
  
  <pre><code>Private Sub Form_Current()
  
   MsgBox ("hello")
  
   Dim strSQL As String
  
   strSQL = "SELECT DISTINCTROW StudentTeachingStatusTbl.ID, StudentTeachingStatusTbl.SuccessStatus FROM StudentTeachingStatusTbl WHERE Active = -1" &amp; _
          "or ID IN (Select SuccessID from StudentTeachingExperiencesTbl where StuId = " &amp; Me.Text2.Value
  
   If Not IsNull(Me.StudentTeachExp_SubF.Controls("SemesterID")) Then
      strSQL = strSQL &amp; " and SemesterID = " &amp; Me.StudentTeachExp_SubF.Controls("SemesterID").Value
   End If
  
   strSQL = strSQL &amp; ")"
  
   Me.StudentTeachExp_SubF.Controls("SuccessID").RowSource = strSQL               
   End Sub
  </code></pre>