I'm throwing myself on the mercy of the court here. I cannot get this DataGridView that is nested in a TabControl Tabpage3 to refresh without refreshing it twice. It's like a zombie DataGridView. I'm opening up a new form and writing dates to the database. When I close the pop-up form I'm calling TabControl1.SelectedIndexChanged which in turn calls this SchTabLoad. Everything fires, but the grid will not refresh until I manually refresh it. I really hope I'm just doing something stupid, because this is driving me nuts.

VB.NET Code:
  1. Dim dtSch As New DataTable 'DataGridView4
  2.     Dim bs4 As New BindingSource
  3.  
  4.     Public Sub SchTabLoad(sender As Object, e As EventArgs)
  5.  
  6.         bs4.ResetBindings(False)
  7.         DataGridView4.DataSource = Nothing
  8.         bs4.DataSource = Nothing
  9.         dtSch.Clear()
  10.  
  11.         'Schedule Tab Production DataGridview4
  12.         Dim sqCon As New SqlClient.SqlConnection(DB)
  13.         Dim sqCmd As New SqlClient.SqlCommand
  14.  
  15.         Dim Adapter As New SqlDataAdapter
  16.         Dim sql As String = "SELECT * FROM  Table"
  17.  
  18.         sqCmd.Connection = sqCon            'create the DB connection
  19.         sqCon.Open()                        'open the connection
  20.        
  21.         Adapter.SelectCommand = New SqlCommand(sql, sqCon)
  22.         Adapter.Fill(dtSch)
  23.         sqCon.Close()
  24.  
  25.         bs4.DataSource = dtSch
  26.         Me.DataGridView4.DataSource = bs4
  27.         Me.DataGridView4.Refresh()
  28.  
  29.     End Sub