Dear All,
Good Day! I need your guidance to solve this problem. I have been stuck for 2 days already.
I am having a form and the record source is link from a table called tblTask.
tblTask keeps many different field and many different date.
In the form, after I enter the Start Date and End Date for the task, the system should show me the Workdays.
The Workdays will come from query, qry3. After I did some calculation.
Now, I manage to query the workdays for a particular task already, but I don't know how to show the result into the form.
Besides that, there will be more than one fields which need to display the result from different queries, so I cannot link the form to a query.
I have tried to use the DLookUp method but it show the error 2001.
I am attaching with my sample code and I really hope you all can help me to solve this problem.
TQVM!