I need to be able to requery a subform when the master form changes from record to record. Do I just put a <br>
Forms![subform].requery in the BeforeUpdate or AfterUpdate event of the Master form? TIA...
Is your sub form linked to the main form?<br>
If your subform and main form have one or more of the same fields then you can just set the Child/Master link to the subform properties. <br>
In which case you don't need to explicitly force a requery.<br>
<br>
If not then are you setting the sub forms recordsouce to something inwhich case the "Forms![subform].requery" should work.<br>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.