[AccessD] Refreshing a form

Ryan W wrwehler at gmail.com
Fri Dec 9 12:34:25 CST 2022


The other way I've done it.. IIRC is if you have a button to open the task
form ln the dashboard:


Private sub btn_Click()
   docmd.Openform "TaskFrm"
   call RefreshRoutine
end sub


IIRC, your code after the openform command shouldn't run until the form
closes.

On Fri, Dec 9, 2022 at 12:28 PM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> Yeah, that's the simple way to do it. I'll do it that way.
>
> Thanks
>
> Rocky
>
>
> On Fri, Dec 9, 2022 at 10:23 AM Ryan W <wrwehler at gmail.com> wrote:
>
> > In the Form_Close event on the task form you can do something like:
> >
> > Dim frm as new Form_DashBoardFrm
> > frm.RefreshRoutine (as long as a public method)
> > set frm = nothing
> >
> > or maybe even just Forms!DashBoardFrm.RefreshRoutine
> >
> >
> >
> >
> >
> > On Fri, Dec 9, 2022 at 12:16 PM Rocky Smolin <rockysmolin2 at gmail.com>
> > wrote:
> >
> > > Dear List:
> > >
> > > I have a dashboard form from which the user can select a task which
> opens
> > > up a task form. Having made changes to the task form and closing it, I
> > > would like the dashboard form to reflect those changes.
> > >
> > > I have a refresh routine in the dashboard form's module and a temporary
> > > button on the dashboard to refresh the form.  I suppose I could call
> the
> > > refresh routine in the dashboard from the task form, but I'm wondering
> if
> > > there is an event which fires when the task form closes and the
> dashboard
> > > gets the focus but I haven't found one that will do that.
> > >
> > > Is there one? Or must I call the refresh routine in the dashboard  from
> > the
> > > task form.
> > >
> > > MTIA
> > >
> > > Rocky
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list