R
rarmont
I'm at a loss at how to do this, so any help is appreciated.
The subform I use to update my employees' insurance deductions is great, but
I have to update their deductions individually (their deductions change after
1 year of service). This is very tedious as we have hundreds of employees
and selecting their name from a drop-down list on the main form, clicking on
the insurance deduction form button, then clicking on the calculate
deductions button, then closing the subform takes a lot of time.
Is there a way to create a command button on the main form that will loop
through the records and execute the command button that calculates the
deductions (that will notify me when it's complete)?
The subform I use to update my employees' insurance deductions is great, but
I have to update their deductions individually (their deductions change after
1 year of service). This is very tedious as we have hundreds of employees
and selecting their name from a drop-down list on the main form, clicking on
the insurance deduction form button, then clicking on the calculate
deductions button, then closing the subform takes a lot of time.
Is there a way to create a command button on the main form that will loop
through the records and execute the command button that calculates the
deductions (that will notify me when it's complete)?