请大家帮忙看看这段代码呀!!

3382345

Private Sub 装箱数量_BeforeUpdate(Cancel As Integer)
Me.净重_箱_kgs_ctn_ = Me.装箱数量 * Me.净重_件_kgs_
End Sub
Private Sub 净重_件_kgs__BeforeUpdate(Cancel As Integer)
Me.净重_箱_kgs_ctn_ = Me.装箱数量 * Me.净重_件_kgs_
End Sub
Private Sub 净重_箱_kgs_ctn__BeforeUpdate(Cancel As Integer)
Me.毛重_箱_kgs_ctn_ = Me.净重_箱_kgs_ctn_ + 1.5
End Sub
我想问问  为什么我输入装箱数量 , 净重/件  ..到最后毛重_箱_kgs_ctn_ 的值是不会根据数据变化而变的,只会手动输入 净重_箱_kgs_ctn   的值  ,,才会变

tz-chf

净重_箱_kgs_ctn__BeforeUpdate没发生怎么会变?
Private Sub 装箱数量_BeforeUpdate(Cancel As Integer)
Me.净重_箱_kgs_ctn_ = Me.装箱数量 * Me.净重_件_kgs_
Me.毛重_箱_kgs_ctn_ = Me.净重_箱_kgs_ctn_ + 1.5
End Sub
Private Sub 净重_件_kgs__BeforeUpdate(Cancel As Integer)
Me.净重_箱_kgs_ctn_ = Me.装箱数量 * Me.净重_件_kgs_
Me.毛重_箱_kgs_ctn_ = Me.净重_箱_kgs_ctn_ + 1.5
End Sub

最好写在afterupdate里