Salut,
mets déjà les balises codes.c'est plus lisible, et à première vue il manque un ; à la fin de ton instrucion SQL
DoCmd.RunSQL "INSERT INTO REPORT (ReportID, ContractID, CustID, MCmodID, MC_Serial, Robot_Serial, Mold_Serial1, Mold_Serial2, MSEID, [Date], HourMeterReading) Values (Form_AuditFirstPage.ReportID & ", 1, " & Form_AuditFirstPage.ComboCust.Column(0) & ", " & Form_AuditFirstPage.ComboMC_Model.Column(0) & ", " & Form_AuditFirstPage.MC_Serial & ", " & Form_AuditFirstPage.RobotSerial & ", " & Form_AuditFirstPage.Mold1Serial & ", " & Form_AuditFirstPage.Mold2Serial & ", " & Form_AuditFirstPage.MSE.Column(0) & ", #" & Form_AuditFirstPage.dat & "#, " & Form_AuditFirstPage.HourMeterReading & ");"
Partager