[AccessD] Refreshing a form

[Ryan W]

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
>>
>