469,647 Members | 1,803 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,647 developers. It's quick & easy.

Multiple Subforms, AfterUpdate?


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
Mar 27 '08 #1
1 1518
grrr - can't delete this anymore

figured out a workaround - please disregard
Mar 28 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Diana Gard | last post: by
1 post views Thread by Barb.Richards | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.