[AccessD] Requery subform

Arthur Fuller fuller.artful at gmail.com
Sun Mar 27 15:48:14 CDT 2022


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


More information about the AccessD mailing list