By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
463,218 Members | 481 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 463,218 IT Pros & Developers. It's quick & easy.

Multiple Subforms, AfterUpdate?

P: 48

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
Share this Question
Share on Google+
1 Reply

P: 48
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.