INSERT INTO yourTableName (Field2integer, Field3Text, Field4Date)
Values (1, "test", #11/21/2019#)
Note that I did not include Field1, which in my case is always an Autonumber and gets created automatically.Dim strSQL as string
strSQL = "INSERT INTO yourTableName (Field2integer, Field3Text, Field4Date) " _
& "Values (1, 'test', #11/21/2019#)"
Currentdb.Execute strsql, dbfailonerror
You can also insert NULLs into fields which accept them.INSERT INTO yourTableName (Field2integer, Field3Text, Field4Date, Field5AllowsNulls)
Values (1, "test", #11/21/2019#, NULL)
HTH