Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Requerying a Subform

Status
Not open for further replies.

nexus

Programmer
Jun 16, 1999
28
0
0
CA
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 &quot;Forms![subform].requery&quot; should work.<br>

 
Thanks, the forms are linked. I wasn't sure if it automatically requeried...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top