script error Help

goju

Registered User.
Local time
Today, 11:47
Joined
Apr 7, 2005
Messages
77
please see below script error,

im' a little lost

CDate(Me.ArchiveDate) = invalid use of null


Private Sub Form_Activate()
Me.TimeSpan = Now() -
End Sub
 
Me.ArchiveDate is returning null values which cDate can't handle.

what do you want to do when there is no date?

Peter
 
not sure i understand

when i archive the information it should take todays date
 
how are you telling ArchiveDate to take todays date?

where/how are you using this line? Date(Me.ArchiveDate)

Peter
 

Users who are viewing this thread

Back
Top Bottom