Search results for query: *

Thanks to you both. However, I'm looking for information on filtering down to the supervisor only being able to view records of those who report to him. I don't believe that setting something up only on the access level will accomplish what I need to do. ?

I am creating an HR (human resources) database that will be used by both the HR department and all supervisors. HR wants to limit what supervisors can see—they want them to see, add performance evaluations, do consultations, etc. only for those employees who report to them. BUT…all of HR...

Thanks to you both. This is good stuff!!

FABULOUS. I was having a difficult time with the quotation placement. THANKS!!!

I answered my own question on the last item above. However, I am a bit lost on what changes when i want to reference text instead of a number. Title is text...I need to filter on that as well.

Thanks...very helpful. I assume this all goes on the OnClick control on the form, correct?

I have a pop up form (fp_training_rpt_select) where the users have options to input data they want to print a report based upon (unbound, form selection fields are: employee, year_start, year_end, title). Ultimately, If the user selects nothing, then I want all records to show on the report...

Remou - you are fabulous! That worked. Thanks a bunch.

Thanks, Remou and dhookom. I've tried the following code in both the On Load and On Format events in the report and get a compile error that the sub or function is not defined when I attempt to print the report form the form. The report will still open with no error if the report is opened...

I have a report for incidents and accidents that, depending on where the report is generated from, a drug_test control needs to be visible or not. If the report is generated from the cmdPrintReport button on the form f_safety, then I want the drug_test control to be visible. If it is printed...