 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2008requerying a subform
Hi, I have a main form with two sub forms on it. The recordsource of the second subform has in it's criteria a reference to the JobID of the first i.e. forms!MainForm!Subform1!JobID. If I put a button on the main form and requery Subform1 from it all is well - Subform2 results update to reflect the job selected in Subform1 What I need, though, and I'm struggling to find, is the syntax to requery the second subform from the on current event of the first subform. Help appreciated Paul If you have the LinkChild/MasterFields set up correctly then the requery should take place automatically by Access. >Hi, > [quoted text clipped - 11 lines] > >Paul  SignatureRuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. The key is that you don't have the criteria expressed in the query itself. Instead you place the field names of the parent field and the child- subform field in the master/child parts of the Data tab of the subform as it resides on the mainform (the parent form). If you do it that way no re-query is required. Ron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.