I have th efollwowing code to enter a record.
when I leave the date field blank and press udpade
I get an error meassage.

is there a way of making my program accept blank entries for the date field? I get the same problem with currency

Private Sub Command1_Click()

Data1.Recordset.AddNew
Data1.Recordset("Name") = Text1
Data1.Recordset("Start_Date") = Text2.Text
Data1.Recordset("End_Date") = Text3.Text
Data1.Recordset("Currency") = Text4.Text
Data1.Recordset.Update

End Sub