[RESOLVED] Using variable fields in recordset

[wussupbuddy]

I guess both, I want to fetch the data and then update using the same method..

e.g
rs.Open "Select " & leavetype.Text & " from leavemaster where empid=" & empid.Text
rs1! & leavetype.Text=total
rs.update