Excellent, it worked. I'm not worried about malicious sql injections... our firewall is excellent. I realize that a datagridview may make more sense, but for the people using our database, textboxes are easier for them to navigate. For those interested in the code

Dim c As New Control
Dim t As New TextBox
For i = 1 To 40
c = Me.Controls("txt" & i)
t = DirectCast(c, TextBox)
t.Text = i
Next

and I'll do the same for updates. thanks a lot!