Auto Fill Calculation on Form

P

pencuri

Joined
Jan 3, 2009
Messages
2
Reaction score
0
How to make auto fill field value (calculation) with data from multiple field0?
I have try like this :

Private Sub field1_AfterUpdate()
Me.field2 = Me.field1.Column(1)
End Sub

Private Sub field2_AfterUpdate()
Me.field3 = ((Me.field2 * 0.01 * Me.field3) / (Me.field3 - Me.field2))
End Sub

but not work.... Have any idea??

rgds,

tedie
 
Back
Top