[AccessD] Refreshing a form

[Rocky Smolin]

The called form can also be called from the Main Menu.  Don't know if that
makes any difference to your advice.

r

On Fri, Dec 9, 2022 at 11:26 AM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

>
>  I usually go the route of making the called form modal, because I think of
> things like this as a pop-up task, rather than something they opened on
> their own, from say a menu.
>
>  It also gives you the ability to check what they did by hiding the form
> and
> not closing it.   That returns execution to the calling form, at which
> point
> you can see what's been done on the called form and respond accordingly.
> Then you close it when you are done with it.
>
>  Of course, every situation is different, and what you do depends on the
> functionality of the called form.   But more often than not, I find it
> cleaner overall to open it as modal.
>
> Jim.
>
>
>
> -----Original Message-----
> From: AccessD On Behalf Of Ryan W
> Sent: Friday, December 9, 2022 1:39 PM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Refreshing a form
>
> Welp. I think I was partially correct.  That works for modal forms but not
> your normal forms.... duh!
> .
>
> On Fri, Dec 9, 2022 at 12:34 PM Ryan W <wrwehler at gmail.com> wrote:
>
> > 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
> >>
> >
> --
> 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
>