Calculations?

[NewfieSarah]

I have a new table called CONRESVALCALC with contain lots of fields. I need to use a command buttons so when the buttons is clicked then a calculation is performed for that specific button. The field Mainarea and unitval have to be multiplyed to have portionval appear. This button can be pressed anytime when adding a new record. or editing. suggestions?? Thanks

sarah

 

[mikelev]

I use the following method:

1.) Create your button on the form
2.) In the OnClick event of the button put the following code:

me.portionval.visible = True
Calculate

Add the following procedure in the form

Private Sub Calculate()
    Me![portionval] = Nz(Me![mainarea], 0) *  Nz(Me![unitval], 0)
End Sub