Datagridview field(comboboxcolumn) not displaying properly when clicked

I have several issues associated with clicking on a new row on a datagridview that contains a comboboxcolumn that is bound to a datatable.

I use a button to add a row to existing rows in a datagridview.  My issues are this:

1)  If I first click on the comboboxcolumn of an existing row where there is a value in the cell, when I click on the same comboboxcolumn cell of the newly added row, it doesn't remain blank.  It populates it with the text of the previously clicked row.  I would think it should remain blank.

2)  I want the dropdown to equal true whenever I click on the comboboxcolumn.  The column style is set to dropdown.  And I also use an EditingControlShowing function to make it drop down (which it does) but there are quirks where it doesn't drop down below the right cell much less the same row depending on the last cell I had focus on.

3)  Once I DO click the appropriate value of the dropdown I want to update the next two cells with values using a sub, but it doesn't execute until I exit the cell.  CellValueChanged doesn't execute until exit of the cell.

If I could resolve these three issues with a datagridviewcomboboxcolumn, it would work FLAWLESSLY for me.

I've included code I use to populate the datagridview, cellvaluechanged and other.

Private Sub LoadLogisticsLines()
        With grdviewLogistics
            .RowHeadersVisible = False
            .AutoGenerateColumns = False
            .DataSource = dvLogisticsLines
            .EditMode = DataGridViewEditMode.EditOnEnter
        End With
        With display_order
            .DataPropertyName = "display_order"
            .HeaderText = "Ord"
            .Width = 30
            .ReadOnly = True
            .Visible = True
        End With
        With action
            .DataSource = dtActionTypes
            .ValueMember = "ID"
            .DisplayMember = "Description"
            .DataPropertyName = "action_type_description"
            .HeaderText = "Action Type"
            .Width = 80
            .ReadOnly = False
        End With
        With pickup_delivery_index
            .DataSource = dvGlobalShippingAddresses
            .ValueMember = "shipping_address_id"
            .DisplayMember = "company_description"
            .DataPropertyName = "pickup_delivery_id"
            .HeaderText = "Pickup/Delivery Locations"
            .Width = 210
            .ReadOnly = False
        End With
        With pickup_delivery_address
            .DataPropertyName = "pickup_delivery_address"
            .HeaderText = "Address"
            .Width = 160
            .ReadOnly = False
        End With
        With pickup_delivery_city_state
            .DataPropertyName = "pickup_delivery_city_state"
            .HeaderText = "City / State"
            .Width = 140
            .ReadOnly = False
        End With
        With pickup_delivery_billing_type_description
            .DataSource = dvLoadUnit
            .ValueMember = "load_unit_id"
            .DisplayMember = "description"
            .DataPropertyName = "billing_type_id"
            .HeaderText = "Billing Type"
            .Width = 70
            .ReadOnly = False
        End With
        With pickup_delivery_billing_count
            .DataPropertyName = "billing_count"
            .HeaderText = "Unit Count"
            .Width = 70
            .ReadOnly = False
            .DefaultCellStyle.Format = "##,##0.00"
        End With
        With pickup_delivery_billing_rate
            .DataPropertyName = "billing_rate"
            .HeaderText = "Rate"
            .Width = 70
            .ReadOnly = False
            .DefaultCellStyle.Format = "##,##0.0000"
        End With
        With pickup_billing_sub_total
            .DataPropertyName = "billing_sub_total"
            .HeaderText = "Sub Total $$"
            .Width = 80
            .ReadOnly = True
            .DefaultCellStyle.Format = "##,##0.00"
        End With
    End Sub

    Private Sub grdviewLogistics_CellValueChanged(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles grdviewLogistics.CellValueChanged
        If Activating Then Exit Sub
        Dim xCell As DataGridViewCell = grdviewLogistics(e.ColumnIndex, e.RowIndex)
        Dim xCellName As String = xCell.OwningColumn.Name
        Select Case xCellName
            Case "pickup_delivery_index"
                Dim drv As DataRowView = dvLogisticsLines(e.RowIndex)
                Dim da As New SqlDataAdapter
                Dim ds As New DataSet
                Dim dt As New DataTable
                da.SelectCommand = New SqlCommand
                da.SelectCommand.Connection = TSFConnection
                da.SelectCommand.CommandType = CommandType.StoredProcedure
                da.SelectCommand.CommandText = "SPS_SelectShippingAddressEntry"
                da.SelectCommand.Parameters.Add(New SqlParameter("@CompanyID", glCompany))
                da.SelectCommand.Parameters.Add(New SqlParameter("@ShippingAddressID", grdviewLogistics.CurrentCell.Value))
                da.Fill(ds, "shipping_addresses")
                dt = ds.Tables(0)
                If dt.Rows.Count > 0 Then
                    drv.BeginEdit()
                    drv("pickup_delivery_address") = dt.Rows(0)("shipping_address1").ToString
                    drv("pickup_delivery_city_state") = dt.Rows(0)("shipping_city").ToString & ", " & dt.Rows(0)("shipping_state").ToString
                    drv.EndEdit()
                End If
            Case "billing_rate", "billing_count"
                Dim index As Integer = grdviewLogistics.CurrentRow.Index
                If (index = -1) Then
                    Exit Sub
                End If
                Dim drv As DataRowView = dvLogisticsLines(index)
                drv.BeginEdit()
                drv("billing_sub_total") = drv("billing_rate") * drv("billing_count")
                drv.EndEdit()
        End Select
        bSave.Enabled = True
    End Sub

    Private Sub grdviewLogistics_EditingControlShowing(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewEditingControlShowingEventArgs) Handles grdviewLogistics.EditingControlShowing
        Select Case grdviewLogistics.CurrentCellAddress.X
            Case 1, 2, 5 ' Action Type, Pickup/Delivery Index , Billing Rate Type
                Dim cbo As ComboBox = CType(e.Control, ComboBox)
                If Not cbo Is Nothing Then
                    If Not cbo.DroppedDown Then
                        cbo.DroppedDown = True
                    End If
                End If
        End Select
    End Sub

Select allOpen in new window