Hi,
In my database, I have a form that contains a subform. The subform is based on single field from departments table i.e department name which select departments from list value in the combobox.Other than the subform, the main form contains all the fields from employees table.The peoblem is when i fill all the fields in the emloyee form n tab to sub form (department)there is an error i.e,


You cannot add or change the record because a related record is required in table 'Departments'

how to solve this error?kindly help me

Thanking U.