Auto Calculate Form

[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

 

[BMaerhofer]

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!