Date/Time Validation for Test Access 2003 Database

[Mango28]

Validate the firstActionDate such that it cannot be before DatetoBreackerD ate and cannot be after current date? I did the following but it does not work!?

Private Sub FirstActionDate_BeforeUpdate(Cancel As Integer)
Rem testing for Me.FirstActionDate can not be after current date
If Me.FirstAcrionDate <= Date Then
    Cancel = True
   Me.FirstActionDate.SetFocus
   MsgBox "Please enter a date that falls prior to today's date"
Rem testing for Me.FirstActionDate can not be after DatetoBreaker date
If Me.FirstAcrionDate < DatetoBreaker Then
    Cancel = True
   Me.FirstActionDate.SetFocus
   MsgBox "Please enter a date that falls prior to first inspection's date"
End If
End Sub

[NeoPa]

Check the spelling of Me.FirstAcrionD ate in your code.
Have you compiled this code ever?
I would frankly expect someone to check this sort of thing before posting a question on here.