REquery Subform
in [Forms]
|
From: RedHeadedMonster via AccessMonster.com on 2 Mar 2010 16:34 I have a subform (frmCamResourcesSUB1 based on a query result) on a main form (frmCamResource). If I want to edit data displayed on the subform. You can click on a name in the subform, a popup comes up that allows you to edit the data. When I close the popup I want to requery the subform so that the new edited data is displayed. I currently have this in the close event of the popup: Forms![frmCamResource].[frmCamResourcesSUB1].Form.Requery which only works if I open the popup a 2nd time and close, or if I close the form and open it again. I've also tried the following with the same results: Forms![frmCamResource].[frmCamResourcesSUB1].Form.Refresh Forms!frmCamResource.frmCamResourcesSUB1.Requery Forms!frmCamResource.frmCamResourcesSUB1.Form.Requery Forms!frmCamResource.Requery I even tried putting the code line twice, since it seemed to want me to run it twice, but still the same result. Its making me CRAZY! Whats worse is I have the same code working perfectly for another subform. What am I missing? Thanx! RHM -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201003/1
|
Pages: 1 Prev: recordset clone Next: Using DLookUp as the default value of a Forms ComboBox |