In MS Access 2010, I am using the after update event on a date field in the primary form to populate/insert a new record in the subform. But my SQL code is not working; please help.
Private Sub Date_AfterUpdate()
Dim strSQL As String
strSQL = "INSERT INTO Comm_Poll_Data ([LCC]) VALUES('A') WHERE Mission.MissionID = Comm_Poll_Data.[Mission ID] AND Comm_Poll_Data.[LCC] IS NULL;"
DoCmd.RunSQL strSQL
End Sub