How to populate a field with result of calc???

[cpaul]

So in a table I have a field that I want populated with the result of an arithmatic expression. For example, one field named VALUE, populated with a form, is a variable in an expression like VALUE * 132. I need to put the result in the same table with VALUE, in a field named RESULT. Is it possible to do this in the form with an expression or is the operation done in the table? I have attempted to write an expression as a calculated control in the form but I don't know how to write the expression to write the result to RESULT in the table.

[comteck]

You didn't say whether you wanted the RESULT to appear with the click of a button, or automatically as you scroll through. IT might work better with the click of a button. Here is how you do it. If you don't want it to happen at the click of a button, let me know.

I'm assuming the form's Record Source is the table with the RESULT field. On the form, create a textbox for RESULT. Make its Control Source the RESULT field.

Then create a command button. Right click on the button, and select "Build Event". Choose "Code Builder". Visual Basic will open, and the following code will appear:

Private Sub Command5_Click()

End Sub

You enter the required code in between the 2 lines. The final code should be:

Private Sub Command5_Click()
Me.Result = Me.Value * 132
End Sub

comteck

[cpaul]

Yes, thank you. Your assumptions are correct. I was hoping for a simple expression that would be defined in the properties dialog box for either the RESULT field in the form or the RESULT field in the table. This does look like a good solution. For the calculation to occur automatically, I think I would just use this code with the RESULT text box property of either "After Update" or "On Change". Got any input on that method?

Thanks Again.

[comteck]

The "Me.RESULT=Me.Value * 132" would be the same code wherever you used it. You right click on the properties of the control, and scroll down to whichever event procedure you wish to use (i.e OnClick, OnCurrent, AfterUpdate, etc). Visual Basic will still open, and the first and last line of the sub will appear. You just put that line in between them.

You might want to play around with them and see which one works best for you.

comteck

[cpaul]

The "Me.RESULT=Me.Value * 132" would be the same code wherever you used it. You right click on the properties of the control, and scroll down to whichever event procedure you wish to use (i.e OnClick, OnCurrent, AfterUpdate, etc). Visual Basic will still open, and the first and last line of the sub will appear. You just put that line in between them.

You might want to play around with them and see which one works best for you.

comteck

Great feedback - very helpful. I am much obliged!!