update table from computed field.

[priac]

How do I update my table from a computed value in text172. [Text172] is computed from =[text126]/[text134]
The update needs to be added to control source "loaded_arm" of [text172]

 

[randy700]

Generally, putting a calculated value into your table is not recommended because you would have to remember to change it whenever any of the fields it's derived from change. That being said, you should be able to use an update query....

dim strSQL as String
strSQL = "UPDATE yourTable SET fieldName = " & me.txt172 & " WHERE ..... "
DoCmd.RunSQL strSQL

Randy