In the code I have, Everything works fine from blank fields in the record. IF I enter information and make a mistake, and have to change the disposition, I need to update the Est_hours and Est_Materials field values back to "0".
Here is the code.
As of now, If I have 3 hours in the Est_hours field and then change the disposition from None to SFR, the Est_Hours field value stays at 3.
Code:
If Me.cmbDisposition = "SFR" Then
Me.Unit_Status = "S"
Me.Est_Hours.Value = "0"
Me.Est_Materials.Value = "0"
DoCmd.OpenForm "frmHours", acNormal
Else
End If