Auto Calculate Form

  • Thread starter Thread starter BMaerhofer
  • Start date Start date
B

BMaerhofer

Here is my situation:

I have two forms: frmInputRecord and frmAuto

I need for when a user inputs mileage it will look at another field for the
interval to update the next oil change.

-------------------------------
frmInputRecord (Table: tblRecords)
Mileage
Next_Oil_Change

frmAuto (Table: tblAuto)
Change Interval
-------------------------------
So:
Mileage + Change Interval = Next_Oil_Change


Auto Fill: Next_Oil_Change based on the interval that was set.

Thanks!!!
Brian
 
Ok Thanks!
But I still can't figure it out.

Private Sub Mileage_AfterUpdate()
Update tblRecords

Set Next_Oil_Change = Mileage + 4000

End Sub

It will not work.

THANKS!
 
Back
Top