Hello-
I have one form frmProject1 (record source tblProject1), with two subforms within it:
1) frmPayroll (tblPayroll), and
2) frmTimes (tblTimes)
Basically, there are multiple different tblProject(n) where n is some number. While the details of each is stored via their respective forms, all of the forms need to link to tblPayroll and record higher-level information (employee, amount of time, etc). So far, this hasn't been a problem.
Unfortunately, frmProject1 recently needed to add subform frmTimes whereas a given employee can leave and re-enter the same project. Thus, individual visits by employee are stored in tblTimes, total hours at a given project is stored in tblProject1, and I need the higher-level pay information stored in the subform with record source tblPayroll. Both subforms are linked to frmProject1 via PK.
Now, for other projects that don't have the additional subform frmTimes, I simply update subform frmPayroll with the event BeforeUpdate. The problem with this Project1 is that BeforeUpdate is called when the user clicks on the subform frmTimes to put in when the employee made visits.
In other words, I need to somehow have the form wait to update the payroll subform until the user changes to a new/different frmProject1 record, and not just when the user clicks on another subform.
Is there some event I dont know about? I can't replace tblPayrol with a query because it gets updated from other forms directly as the only storage of information.
thank you, as always
I have one form frmProject1 (record source tblProject1), with two subforms within it:
1) frmPayroll (tblPayroll), and
2) frmTimes (tblTimes)
Basically, there are multiple different tblProject(n) where n is some number. While the details of each is stored via their respective forms, all of the forms need to link to tblPayroll and record higher-level information (employee, amount of time, etc). So far, this hasn't been a problem.
Unfortunately, frmProject1 recently needed to add subform frmTimes whereas a given employee can leave and re-enter the same project. Thus, individual visits by employee are stored in tblTimes, total hours at a given project is stored in tblProject1, and I need the higher-level pay information stored in the subform with record source tblPayroll. Both subforms are linked to frmProject1 via PK.
Now, for other projects that don't have the additional subform frmTimes, I simply update subform frmPayroll with the event BeforeUpdate. The problem with this Project1 is that BeforeUpdate is called when the user clicks on the subform frmTimes to put in when the employee made visits.
In other words, I need to somehow have the form wait to update the payroll subform until the user changes to a new/different frmProject1 record, and not just when the user clicks on another subform.
Is there some event I dont know about? I can't replace tblPayrol with a query because it gets updated from other forms directly as the only storage of information.
thank you, as always
Comment