If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add record(s) automatically
I have a sub-form that we enter employee, employee hours, pay category, etc.
to. On the line that we enter data on there is a check box 'Hazard Pay'. I would like, if the check box is checked, to add a record for each employee entered that automatically fills in the same employee, but with a standard employee hours, and a pay category of HAZ. This does not have to show on the sub-form, but needs to be added to the table at minimum. Better yet I would like to have the Hazard Pay check box on the main form and when selected (after the sub-form) to have each employee have a record added for his hazard pay. Hope this makes sense and I hope someone can help me a bit. Thanks. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201003/1 |
#2
|
|||
|
|||
Add record(s) automatically
It sounds like you want to give HazPay for all hours worked, not just those
the employee actuall performed a hazardous task. Then why not a checkbox in the employee record instead of hours record? -- Build a little, test a little. "osupratt via AccessMonster.com" wrote: I have a sub-form that we enter employee, employee hours, pay category, etc. to. On the line that we enter data on there is a check box 'Hazard Pay'. I would like, if the check box is checked, to add a record for each employee entered that automatically fills in the same employee, but with a standard employee hours, and a pay category of HAZ. This does not have to show on the sub-form, but needs to be added to the table at minimum. Better yet I would like to have the Hazard Pay check box on the main form and when selected (after the sub-form) to have each employee have a record added for his hazard pay. Hope this makes sense and I hope someone can help me a bit. Thanks. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201003/1 . |
Thread Tools | |
Display Modes | |
|
|