Updating record from textbox

[gsandy]

I have a form (frmHourEnter) with a textbox (Week_No_Calc) which has a calculation, in Control Source, based on another textbox. After exiting from Week_No_Calc how can I get a field (Week_No) in table (tblHourEnter) to be updated with the calculated value? Thank Sandy

 

[pbaldy]

How about:

http://allenbrowne.com/casu-14.html

 

[gsandy]

Hi Paul, Once the calculation in the form has been done I want the result to go to the table. I do not want the result in the table field to change even if the the other field does change. I do not want to use "calculated field" in the table (available in Access 2010. Thanks Sandy.

 

[pbaldy]

You could use Allen's method and add a test to see if the bound textbox already has a value. Only update if not.

 

[gsandy]

The calculation I am doing is "=DatePart("ww",[Week_Ending],1)" and the calculated field in the table wont allow this!

 

[pbaldy]

I've never used the calculated field, sorry.

 

[gsandy]

Thanks anyway, Sandy.