[RESOLVED] How to Auto copy last record of column to text box and divide the value.

[jmcilhinney]

It's a simple case of getting the last DataRow from the DataTable, getting the values from the two fields, performing the division and then displaying the three values:

Dim rows = dtRecords.Rows
Dim lastRow = rows(rows.Count - 1)
Dim totalOk = CInt(lastRow("TotalOK"))
Dim total = CInt(lastRow("Total"))
Dim yield = totalOk / total
 
totalOkTextBox.Text = totalOk.ToString()
totalTextBox.Text = total.ToString()
yieldTextBox.Text = yield.ToString("p2")

Note that the format specifier "p2" formats a number as a percentage with two decimal places, which includes multiplying by 100.