You must enter a value

[yrstruly]

Please see my data model and my join below. I created a tblTreatmentHistory and Form, form links from frmQuarantine Information with a button. When i click save i get the above error. Please assist?


Files/Documents:
https://docs.google.com/document/d/1...f=true&sd=true

https://docs.google.com/document/d/1...f=true&sd=true

https://drive.google.com/file/d/1I5F...usp=drive_link

Code to link to History table

SELECT * FROM tblTreatmentHistory;SELECT tblQuarantineInfo.QuarantineID, tblQuarantineInfo.PlantID, tblQuarantineInfo.Condition_on_import, tblQuarantineInfo.Mites_on_import, tblQuarantineInfo.Fumigation_on_import, tblQuarantineInfo.Hot_water_treatment_on_import, tblQuarantineInfo.Nr_units_established, tblQuarantineInfo.Estimated_date_of_release, tblQuarantineInfo.Action_plans, tblQuarantineInfo.Tissue_culture_Laboratory_name, tblQuarantineInfo.Tissue_culture_No_of_plants_to_be_multiplied, tblQuarantineInfo.Date_of_destruction_in_quarantine, Plants.Cultivar AS [Variety Denomination], Plants.Clone, tblQuarantineInfo.QualityStatus, tblPlantInspection.InspectionID, tblPlantInspection.InspectionDate, tblPlantInspection.DiseaseStatus, tblPlantInspection.PestPresence, tblPlantInspection.NutrientDeficiency, tblPlantInspection.PhotoPath, tblPlantInspection.ReportPath, tblPlantInspection.Comments, tblPlantInspection.PlantID AS PlantID_tblPlantInspection
FROM (tblQuarantineInfo INNER JOIN Plants ON tblQuarantineInfo.PlantID = Plants.PlantID) LEFT JOIN tblPlantInspection ON tblQuarantineInfo.PlantID = tblPlantInspection.PlantID;

Joining three tables code.

SELECT tblQuarantineInfo.QuarantineID, tblQuarantineInfo.PlantID, tblQuarantineInfo.Condition_on_import, tblQuarantineInfo.Mites_on_import, tblQuarantineInfo.Fumigation_on_import, tblQuarantineInfo.Hot_water_treatment_on_import, tblQuarantineInfo.Nr_units_established, tblQuarantineInfo.Estimated_date_of_release, tblQuarantineInfo.Action_plans, tblQuarantineInfo.Tissue_culture_Laboratory_name, tblQuarantineInfo.Tissue_culture_No_of_plants_to_be_multiplied, tblQuarantineInfo.Date_of_destruction_in_quarantine, Plants.Cultivar AS [Variety Denomination], Plants.Clone, tblQuarantineInfo.QualityStatus, tblPlantInspection.InspectionID, tblPlantInspection.InspectionDate, tblPlantInspection.DiseaseStatus, tblPlantInspection.PestPresence, tblPlantInspection.NutrientDeficiency, tblPlantInspection.PhotoPath, tblPlantInspection.ReportPath, tblPlantInspection.Comments, tblPlantInspection.PlantID AS PlantID_tblPlantInspectionFROM (tblQuarantineInfo INNER JOIN Plants ON tblQuarantineInfo.PlantID = Plants.PlantID) LEFT JOIN tblPlantInspection ON tblQuarantineInfo.PlantID = tblPlantInspection.PlantID;

[ranman256]

in the table, do you have the field property set
REQUIRED = TRUE
or
VALIDATION RULE
or
ALLOW ZERO LENGTH = false