C
Cory
Ok, here's what I want to do. I have created a form that will pull employee
records out using a query based on who their manager is. What I want to do
is make it so that of those records I can select sets of BP's to change who
their manager is on a mass level. I have created the form to display who the
current manager is then there is a drop down where the new manager can be
selected. At the bottom of the form is a list of the BP's under the original
manager (pulled out by the query) and I have put a checkbox named Slct to
check those records I wish to change. I have also made a Save button so that
when i am ready I can make the change. I can't get the code to have it so
after I have selected those records to change and changed the manager that
after hitting Save it changes only the selected records. Right now it will
work but only to the last record I clicked on. I have been playing with some
if then statements but nothing has worked yet. Any help would be greatly
appreciated. Also this is a FE/BE database. I am doing these changes to the
front end and have put that new Slct checkbox in the backend and have added
it to my query. This will eventually be made an MDE file.
records out using a query based on who their manager is. What I want to do
is make it so that of those records I can select sets of BP's to change who
their manager is on a mass level. I have created the form to display who the
current manager is then there is a drop down where the new manager can be
selected. At the bottom of the form is a list of the BP's under the original
manager (pulled out by the query) and I have put a checkbox named Slct to
check those records I wish to change. I have also made a Save button so that
when i am ready I can make the change. I can't get the code to have it so
after I have selected those records to change and changed the manager that
after hitting Save it changes only the selected records. Right now it will
work but only to the last record I clicked on. I have been playing with some
if then statements but nothing has worked yet. Any help would be greatly
appreciated. Also this is a FE/BE database. I am doing these changes to the
front end and have put that new Slct checkbox in the backend and have added
it to my query. This will eventually be made an MDE file.