Hello, working in access 2003, been looking at various solutions for this problem, but can't seem to get any of them to work.
I have a main form EmployeeTask where the user picks an employee, a task, and some other fields from comboboxes. Then the user can update or insert these fields into the Tasks table. But what I also need to be able to do is show the user the tasks for the employee that he picks that are currently in the Tasks table- i.e. prior to his update. I tried setting up a button whose on-click event would populate a textbox control source with the fields of a select statement whose parameters are the values the user picks from the form comboboxes. This doesn't work- gives me an object required error. So I'm sure that a textbox would not accomplish what I need here- unless I'm doing it totally wrong.
Dlookup doesn't work for me because I need all the fields displayed, not just one.
I am looking into setting up a subform based on the parameter query, but not sure how to do that either. Which property of the subform do I put the parameter sql statement into?
I would appreciate any help on this. I don't need any code written for me- if someone could just set me on my way to the best way to accomplish this, that would be awesome.
Thank you in advance and happy holidays!
I have a main form EmployeeTask where the user picks an employee, a task, and some other fields from comboboxes. Then the user can update or insert these fields into the Tasks table. But what I also need to be able to do is show the user the tasks for the employee that he picks that are currently in the Tasks table- i.e. prior to his update. I tried setting up a button whose on-click event would populate a textbox control source with the fields of a select statement whose parameters are the values the user picks from the form comboboxes. This doesn't work- gives me an object required error. So I'm sure that a textbox would not accomplish what I need here- unless I'm doing it totally wrong.
Dlookup doesn't work for me because I need all the fields displayed, not just one.
I am looking into setting up a subform based on the parameter query, but not sure how to do that either. Which property of the subform do I put the parameter sql statement into?
I would appreciate any help on this. I don't need any code written for me- if someone could just set me on my way to the best way to accomplish this, that would be awesome.
Thank you in advance and happy holidays!
