Append Data from text box.

[travismp]

tbl_RECORDS
qry_ADD
frm_ADD

I have a basic form that shows one current record from my qry_ADD.

[TotalHours] is a column that tracks total hours worked on a project.
[Text22] is an unbound box that my tech will enter current number of hours worked.
[Text55] has a formula in the control source of =[Text22]+[TotalHours]

This all works perfect. I now want to add some functioning to my form like a button or something that will replace [TotalHours] with the new number in [Text55]


example: My tech pulls up job #15. There is already 10 Hours listes in [TotalHours] so he then adds 7 hours into [Text22] which in turns shows 17 in [Text55] for a new total of 17 hours spent on this project.

So what can I add to my form that will then change the 10 to 17 in [TotalHours].

Thanks.

 

[Moniker]

UPDATE YourTableName SET YourTableName.[TotalHours] = Text55 WHERE YourTableName.[JobID] = YourJobIDVariable;

Consider giving your controls meaningful names. Text22 and Text55 tell you nothing about what they are.