[AccessD] Requery subform

Paul Wolstenholme Paul.W at industrialcontrol.co.nz
Sun Mar 27 16:44:43 CDT 2022


I find the act of writing down the problem clearly can be an effective
problem solving tool.
On a good day, I've been known to figure it out before hitting the send
button.

On Mon, 28 Mar 2022 at 09:48, Arthur Fuller <fuller.artful at gmail.com> wrote:

> Thanks, Paul. After I sent the message,  I figured it out.
>
> On Sun, Mar 27, 2022 at 4:11 PM Paul Wolstenholme <
> Paul.W at industrialcontrol.co.nz> wrote:
>
> > Arthur,
> >
> > I would try
> > Me.Customer_Edit_frm_Subform.FORM.Requery
> >
> > Paul
> >
> > On Sun, 27 Mar 2022 at 04:35, Arthur Fuller <fuller.artful at gmail.com>
> > wrote:
> >
> > > In the main form is a combo listing Projects. The subform lists
> Machines
> > > for the selected Project. The combo's AfterUpdate event contains the
> > line:
> > > <code>
> > >     Me.Customer_Edit_frm_Subform.Requery
> > > </code>
> > > This doesn't work. Is my syntax correct?
> > > It has also occurred to me to use the subform's Filter property, which
> (I
> > > think) automatically requeries the subform when I invoke the
> ApplyFilter
> > > event. But maybe setting the Filter is enough. I don't know. Advice?
> > >
> > >
> > > --
> > > Arthur
> > > --
> > > 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
> >
>
>
> --
> Arthur
> --
> 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