Dear,
In attachment is a part of my application for task management etc... (I explained some details in my previous post: https://www.accessforums.net/showthread.php?t=66013).
I have a table called Contacts (this is, logically, a table for contact information).
Also, I have a query called "Contacts Extended", which collects information from the table Contacts, and joins First and Last name as one name, called Zaposleni (eng. Employee).
I've created a Report called "Obuke - po zaposlenom", which presents all trainings by employee, stored in table Obuke (eng. Training). I've grouped a report by field ImeZaposlenog, which represents a name of the employee.
Hence, I have a form called "Statistika" and combobox on it. For this combobox I've set Row Source:
SELECT [Contacts Extended].ID, [Contacts Extended].[Zaposleni] FROM [Contacts Extended] ORDER BY [Contacts Extended].[Zaposleni];
and this gives me a list of all employees.
Now, I have a problem when click on the one of employees. I want to open a mentioned report "Obuke - po zaposlenom", but only for that employee.
I tried to build a macro in After Update option, but this gives me a full report, for all employees.
Thnx in advance!
Aleksandar