On the "On Close" event of your popup form, try using Form_MY_MAINFORM_NAME.Requery
"kobi via AccessMonster.com" <u24890[ at ]uwe> wrote in message news:65f1b22e8019f[ at ]uwe...
[Quoted Text] > I have an Access adp project with one main form with 2 subforms attached
to > it. From this form, I call a number of pop up style forms to add data since > I can't add the records to a linked subform. However, when I come back to > the main form, I must select Record-Refresh before the new records are > displayed. I have tried a number of combinations for Refresh and Requery to > do this programmatically, but can't seem to get it to work. I'm wondering if > I'm attaching the Refresh statement to the wrong event or something. I've > tried On Got Focus, On Current and On Activate. Any ideas? > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200609/1 >
|