Setting Date Field In Recordset To Null

Error 1: Setting Date Field in Recordset to null

Error 1: Setting Date Field in Recordset to null " data conversation error 3421 "

Solution: If the field is null set it back to itself .

Here is a simple dummy example i wrote to demonstrate the solution ( look for the bold text in side the code )

Code:
Sub Event_btnSaveEndTime ()
dim strEndDate as string
With Form_frmMainForm
strEndTime = .txtEndTime.Value

[code]....