I've designed a data entry system that uses a public function that uses screen.activeform to resize each main form and its subform and to reposition controls to accomodate differing numbers of records in the subform. This works fine.

I've designed similar forms with subforms to review the data and these are unable to use the public resize function during loading because there is no active form at the time the function is called.

Using debug to step through the loading sequences I find that with the data entry forms, a blank window displays immediately the OnLoad procedure starts and is gradually populated during the procedure, hence there is always an active form. The data review forms don't display until the OnLoad procedure completes, hence I can't refer to the active form.

As far as I can see, the two sets of forms are basically the same in the way they obtain and display data. What is it that allows one set to display immediately and the other to remain invisible until all OnLoad procedures are complete?

Hi Bob,
Being not that experienced in VBA, I'm unfamiliar with the anomoly you're experiencing.
Not to assume you haven't thought of this already, but as an alternative, could you apply your public function to a different event on the form?
eg; OnActivate, OnCurrent, OnEnter....
Just a thought, good luck either way!