View Single Post
  #2 (permalink)  
Old February 10th, 2006, 08:52 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Please post in Microsoft Office > Access VBA

I think the Requery needs a reference. Can you refer to the control in this code? If you are requerying the recordsource for one of your subfoms, I am not sure how you might do that.

A hardcore approach might be to freeze the screen, then close and reopen the whole form system while referring to the current PK on the main form.

HTH


mmcdonal
Reply With Quote