if field changes show msg box to recaluclate

D

deb

I have a continuous form called fProjectColumns.
One of the fields is called OVmo and has the following code...
Private Sub Form_Current()
If IsNull(Me.OVmo) Then Me.OVmo = [OrderValueK] / [Months]
End Sub

User may enter an amount or keep the default above.

What is the best way to handle this...
If [OrderValueK] or [Months] is changed then display msg box showing the
current amount in OVmo and ask user if they want to keep this amount or
recalculate.
If they choose keep then do nothing and if they choose recalculate then
[OrderValueK] / [Months].

Please help with this code.

Thanks in advance
 
Top