[AccessD] I used to be young and stupid

[Rocky Smolin]

Additionally, "a good program is one that works". No one ever reads your
code.

r

On Sat, Jan 15, 2022 at 2:47 PM Arthur Fuller <fuller.artful at gmail.com>
wrote:

> One thing has changed: now I'm old.
>
> I'm working on an app that I began 17 years ago and have revised several
> times as legal requirements, functional requirements and UI fashions have
> evolved. while wandering through the ancient code, I came across this.
> <snippet>
> If FormIsOpen("AssessID_Data_LC_Frm") Then
>     Forms!AssessID_Data_LC_frm!CompanyID_cmbx.Requery
>     Forms!AssessID_Data_LC_frm!ProjectID_cmbx.Requery
>     Forms!AssessID_Data_LC_frm!CompanyID.Requery
>     Forms!AssessID_Data_LC_frm!ProjectID.Requery
>     Forms!AssessID_Data_LC_frm!LocationID.Requery
> End If
> </snippet>
>
> I wonder whether there is a more efficient way to do this, such as setting
> a reference to the form, and for that matter just re-querying the form
> instead of its controls individually.
>
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>