[AccessD] Requery subform

Stuart McLachlan stuart at lexacorp.com.pg
Sun Mar 27 17:13:07 CDT 2022


I'm often an ohnosecond slower than that.

Ohnosecond:  the very small time interval between hitting Send, Delete or some such 
irrevocable keystroke  and realising you have made a mistake.


On 28 Mar 2022 at 10:44, Paul Wolstenholme wrote:

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