Hello, sorry for the broad title...
I've created/manage a moderately-sized database (40 tables, 60 forms, or close to it) and I've run into two scenarios things that I'm not sure is the most ideal approach.
Is there a difference from a performance perspective to keep the a singular, active form open or having multiple forms open? In a typical day my users would have up to four forms open at once, but only interacting with one at a time. Would they notice a performance increase by only keeping one active form open at a time?
Next question. What approach would the general community use to run code after the from has loaded and displayed itself on the screen? The On_Load event runs code during load, but not before the form is displayed. What I've been doing is putting code in the Timer event and setting the Timer Interval to 0 at the end of my code. Is there a more ideal way to do this?
TIA
I've created/manage a moderately-sized database (40 tables, 60 forms, or close to it) and I've run into two scenarios things that I'm not sure is the most ideal approach.
Is there a difference from a performance perspective to keep the a singular, active form open or having multiple forms open? In a typical day my users would have up to four forms open at once, but only interacting with one at a time. Would they notice a performance increase by only keeping one active form open at a time?
Next question. What approach would the general community use to run code after the from has loaded and displayed itself on the screen? The On_Load event runs code during load, but not before the form is displayed. What I've been doing is putting code in the Timer event and setting the Timer Interval to 0 at the end of my code. Is there a more ideal way to do this?
TIA
