Originally Posted by
Edgar
You got the error you described because the query of the form was setup in a way that required EmpID, I did the following changes:
Employee Leave form:
Changed query source to the EmpLeaves table
Changed name of Designation textbox to txtDesignation, same for Type
Changed Emp_ID recordset to add Designation and Type
Added to Emp_ID an after_update event to populate Designation and Type
Changed query source of the subform to a query that would show all employee leaves + type of leave and employee name
You can take it from here. Reconfigure your search to filter by those fields.
Let me know how it goes.