Here is the update code:
con.execute("Update DaysTaughtAndClaimed set recdate='"&request("recdate"&getrec("id"

)&"',Reason='"&Replace(NewReason("Description"

,"'","''"

&"', ReasonCode="&NewReason("Code"

&", sub1Payrate='"&request("sub1Payrate"&getrec("id"

)&"', sub1percentageofday="&request("sub1perecnt"&getrec("id"

)&", PercentageOfDay="&request("perecnt"&getrec("id"

)&", PortionOfDay='"&request("portion"&getrec("id"

)&"',ReasonType='"&getRType("ClaimableorUnclaimable"

&"/"&getRType("WithpayorWithoutpay"

&"' where id="&getrec("id"

)
basically i create a report that retrieve records from the database. I store the info in textboxes with the name of the field and the id of that record. Here they can make changes and then update to the table.