Code:
Private Sub Form_Load()
If Me!rabiesduedate < Date - 30 Then
MsgBox "Vaccinations are due"
End If
End Sub
Not sure this will really accomplish what you want. If Dashboard is bound to dataset (is it displaying records in Continuous view?). The code will read rabiesduedate from the first record only.
In post 3 what is 'upcing'?
If you want to provide db for analysis, follow instructions at bottom of my post. If zip still too large, can upload to fileshare site such as Box.com and post link to file.