For very complicated reasons I'm developing an access 2007 database linked to a MySQL backend, which uses unbound controls which are populated via code. It pulls the data over with a pass-through query which is done very quickly. I've gotten the loading of the data from the query to the form down to about .05 seconds per control, which is fine for smaller forms, but you can imagine the exponential growth with larger forms. There are a few forms with upwards of 125+ controls.
I use the following code to load the data to the form:
Do Until counter = max + 1
frm("d" & counter) = ELookup("f" & counter, "qryLoad_Data")
counter = counter + 1
Any ideas on how I can further speed up the code?