Hello,
I need to have the form update with a future Mileage.
I have a Mileage field, Next_Oil_Change field (checkbox), and Vehicle field
(dropdown).

I have a checkbox for what type of repair that it is, I need it to put a
future mileage based on if the Oil_Filter Change box is check marked.  I need
two options with this as well.

1. Oil_Filter Change checked = 4000 miles added to Next_Oil_Change box  -
all other cars get 4000 unless truck is selected!
2. Oil_Filter Change checked = 7000 miles added if Truck is selected from
vehicle type Next_Oil_Change box
3. Oil_Filter Change NOT checked = The program doesnt fill in the
Next_Oil_Change box.

Private Sub Mileage_AfterUpdate()
If Mileage > 0 And "Oil_Filter Change" = True Then
      [Next_Oil_Change] = Mileage + 4000

If Mileage > 0 And Vehicle = TRUCK Then
       [Next_Oil_Change] = Mileage + 7000

End If
End If
End Sub

-- This will work for the 4000 mileage range but not the 7000, and it is
ignoring if the checkbox is checked or not.

Thanks!!