Tricky Query

[jepoysaipan]

Hi All,

I have attached a file which I need a help from, I need the subform to be populated based only on the Employee Code and the Dates where the employee logged-in a Job Order.

I dont have any code on the cmd button for I am lost on what will be the query statement to update the subform datasheet.

Thanks.

 

[Jon K]

See the database. The subform is based on Query1.
.

 

[jepoysaipan]

Hi Jon,

Thanks for the sugestion, I have tried that approach, but the thing is that I want to filter the Date From & To based on the selected EmpCode thats why on the AfterUpdate event on the attached file I have to set the value for the below combo boxes.

Thanks for the input.