I have declared a variable Private under Option Explicit etc.
I am trying to keep track of when a change occurs.
I have not been able to complete my testing because I get errors.
Private oseasonal as date
If IsNull(Me.[seasonal_updated]) Or Nz(Me.[seasonal_updated]) = "" Then
oseasonal_updated = CDate("00/00/00")
oseasonal_updated = Me.seasonal_updated
I get a type mismatch on this line: oseasonal_updated = CDate("00/00/00")
I get a type mismatch when I have tried oseasonal_updated = " " also.
I have not gotten to the section below that takes the date and converts to string:
If oseasonal <> Me.seasonal Then
midno = mid
blastupdate = olast_updated
bupdateby = oupdated_by
bchange = "Seasonal Updated was " & month(oseasonal) & "/" & day(oseasonal) & "/" & year(oseasonal)
lastupdate = Me.LAST_UPDATED
updateby = Me.UPDATED_BY
change = "Seasonal Updated is " & & month(me.seasonal) & "/" & day(me.seasonal) & "/" & year(me.seasonal)
I do not know if I have approach the date to string correctly.