C
Cal
Hi there
My situation is this: I have a database that tracks requests for customer service. The main form should track all requests for all employees.
I want seperate forms (there are only 3-4 employees involved) that each employee can see that will only allow him to view/edit his open requests
My questions are these
1) Can I limit the forms that each person can see
2) How do I get the form to filter on default? I changed the form's filter property toLookup_Combo30.EmployeeLast="Whittaker")), but it doesn't filter it when it's opened
Any ideas
Thanks
My situation is this: I have a database that tracks requests for customer service. The main form should track all requests for all employees.
I want seperate forms (there are only 3-4 employees involved) that each employee can see that will only allow him to view/edit his open requests
My questions are these
1) Can I limit the forms that each person can see
2) How do I get the form to filter on default? I changed the form's filter property toLookup_Combo30.EmployeeLast="Whittaker")), but it doesn't filter it when it's opened
Any ideas
Thanks