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

Updating value in one subform cancels out update in other subform

P: 1
I have a parent form with four tabbed subforms. On subform x, selecting a value from a combo box should update a few controls on this subform, as well as a control on subform y, all done using dlookups. Each of the controls does have a valid control source in the same table. Right now, I can update the controls on subform x with no problem. When I add the code to update subform y, however, the control in subform y updates and saves the value, but the updates made in subform x are not saved when move away from and return to the subform. Here is how my code looks:
Expand|Select|Wrap|Line Numbers
  1. Private sub cboControl_AfterUpdate():
  2.  
  3. control = Dlookup(...)
  4. Me.Parent.subformy!control = Dlookup(...)
  5.  
  6. End sub
I appreciate any help with this, because it's driving me nuts. Thanks in advance,
Stephen
Oct 7 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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