PMFJI
If SiteId is a text data type, then add the quotes (red) into the SQL as shown. June7 mentioned they were missing.
CurrentDb.Execute "INSERT INTO MyTable(Datadate, SiteID) VALUES(#" & dteDate & "#, '" & Me.SiteID & "')"
Create multiple new records using a start and end date on a form
Moderator
Windows XP 
Access 2003
PMFJI
If SiteId is a text data type, then add the quotes (red) into the SQL as shown. June7 mentioned they were missing.
CurrentDb.Execute "INSERT INTO MyTable(Datadate, SiteID) VALUES(#" & dteDate & "#, '" & Me.SiteID & "')"
Novice
Windows 7 64bit Access 2010 64bit
Thanks for the help, works perfectly now
Form to create multiple records and update others
Possible to have a form that will create multiple records in a table?
Posting Permissions
Reply With Quote