Novice
Windows 7 64bit 
Access 2007
I have a subform on a tab that queries a database modified on other tabs of the main form.
How do I see that this subform requeries when I switch back and forth between tabs? The subform in question now stays unchanged after I modify the data, unless I leave the master record and return. Thank you!
Administrator
Windows 7 64bit Access 2010 32bit
It sounds like you need to save the "Master Record" for the SubForms to see the changes.
VIP
Windows XP Access 2010 32bit
Might have to Requery or Refresh the subform.
The trick is figuring out what event to put the code in. Maybe the Click event of the tab control page.
Me.subformcontrolname.Requery
or
Me.Subformcontrolname.Refresh
RuralGuy makes a good point. If the data entered is into record of the main form. But why would a subform have the same data as the main form?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
SubForm Update
Update field in table after update on a subform
update recordsource of subform
Posting Permissions
Reply With Quote