Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: Refresh Form

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Refresh Form
"kobi via AccessMonster.com" <u24890[ at ]uwe> 07.09.2006 17:13:27
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

Re: Refresh Form
"Powderfinger" <PFinger[ at ]msn.com> 12.09.2006 13:11:47
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
>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net