[AccessD] I used to be young and stupid

[John Colby]

with Forms!AssessID_Data_LC_frm
    !CompanyID_cmbx.Requery
    !ProjectID_cmbx.Requery
    !CompanyID.Requery
    !ProjectID.Requery
    !LocationID.Requery
end with

A little more readable.

On Sat, Jan 15, 2022 at 5: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
>


-- 
John W. Colby
Colby Consulting