[AccessD] I used to be young and stupid

Rocky Smolin rockysmolin2 at gmail.com
Sat Jan 15 20:11:43 CST 2022

Nothing wrong with requerying combo boxes.  I find I have to do that when a
form can delete a record.  SO that the combobox doesn't show #Deleted.
Which confuses the users resulting in support calls.

But what were the others for?


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

> 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

More information about the AccessD mailing list