Adding a specific person's report to a filtered database

[TopGearDog]

Hi -

I have a time entry database where employees are to go and log their projects and say how many hours were spent on the project. I have a login screen that uses a combobox with a list of employee names and when they click their name it takes them to a filtered split form that displays their time entries. I created reports that show them their older time entries and I want this report to show up as a button on the split form. Basically is there a way to code the login combobox to not only filter the split form but to also place the corresponding employees report on the form so they can click it and see their past time entries?

If that isn't possible, is there another way to display a report that only the person logged in can see? I can easily create a form that lists all of the employees out with links to their corresponding report, but I don't want everyone to be able to see everyone else's hours.

Thanks - Sorry if this is confusing. Let me know if you need anything clarified.

[June7]

Filter the report.

If user can select any name from combobox, what stops them from viewing anyone's info?

[ranman256]

You can use the network login, once valid, then plug the userid in a box and pull the records that way.
(instead of a changable combo box)