Solved Insert Into SQL statement (1 Viewer)

[Momma]

Hi
I'm getting a Syntax error in the RunSQL statement. It must be something to do with the date because it works fine when I leave it out. I did a compile with no errors.

DoCmd.RunSQL "INSERT INTO tblDogsChecklist (ContactID, DogID, InfoEmail) " & _
      " VALUES ContactID, DogID, (date())"

 

[theDBguy]

Is InfoEmail a date field?

 

[Momma]

Is InfoEmail a date field?

Yes it is.

 

[cheekybuddha]

The left paren before (date()) should move between VALUES and ContactID

DoCmd.RunSQL "INSERT INTO tblDogsChecklist (ContactID, DogID, InfoEmail) " & _
      " VALUES (ContactID, DogID, date())"

hth,
d

 

[Momma]

The left paren before (date()) should move between VALUES and ContactID

DoCmd.RunSQL "INSERT INTO tblDogsChecklist (ContactID, DogID, InfoEmail) " & _
      " VALUES (ContactID, DogID, date())"

hth,
d

 

[Momma]

The left paren before (date()) should move between VALUES and ContactID

DoCmd.RunSQL "INSERT INTO tblDogsChecklist (ContactID, DogID, InfoEmail) " & _
      " VALUES (ContactID, DogID, date())"

hth,
d

That worked, thank you so much. I appreciate your help!