Hello All,
I am a long time reader, but a first time writer. I have a database for tracking training within my organization. Each employee is assigned specific tasks from a master task list. From there, each employee updates the assigned tasks as they are completed. I have a form titled "Update", which is based on a query with the criteria based on the current user. The form has a combo box with shows the tasks. However, the combo box shows all tasks, and not only the assigned tasks. I am trying to either limit the results of the combo box to only show assigned tasks, or apply a filter through a command button to toggle between all tasks and only the assigned tasks. The query criteria is set to show only required tasks, and when I run the query, it displays correctly. However, I haven't figured out how to make the combo box only display the required tasks.
Thank you for your help...