123dstreet
Registered User.
- Local time
- Today, 15:10
- Joined
- Apr 14, 2010
- Messages
- 122
Hello,
I am creating a Timesheet/Payroll database, on the main timesheet form there are about 100 text boxes where the user can enter their hours (10 days in the pay period x 10 different possible tasks.
In order to update the total hours immediately, I require the following for each textbox:
I don't feel like writing this for all 100 text boxes, it seems there should be a more efficient way of writing this code.
Any ideas?
D
I am creating a Timesheet/Payroll database, on the main timesheet form there are about 100 text boxes where the user can enter their hours (10 days in the pay period x 10 different possible tasks.
In order to update the total hours immediately, I require the following for each textbox:
Code:
Private Sub Text20_AfterUpdate()
Me.Refresh
End Sub
I don't feel like writing this for all 100 text boxes, it seems there should be a more efficient way of writing this code.
Any ideas?
D