[AccessD] Refreshing a form

[Jim Dettman]

 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