I have a main form containing a subform. As the subform query takes a few minutes to complete and the information doesn't need to be available immediately anyway, I want to delay the subform query until I click an update button instead if it delaying the opening of the main form.
Is there anything built in to VBA to prevent a subform from loading the data when the main form is opened? Presumably to get the subform to update afterwards you'd just refresh / requery the subform on the button click event???
When I do update the data in the subform, I'd like columns 1, 2, 3, 5 and 6 to be fixed at a particular width and column 4 do expand to what ever is available. My thinking is when the mainform loads, I'll get the subform width and subtract the fixed column widths of 1, 2, 3, 5 and 6 before making column 4 width whatever value if left over.
How to you access the subforms column from the mainform? Is there an easier way to do this? I wondered whether you could do this from the subform itself but I'm not sure it could determine it's width on the mainform...
Thanks
Is there anything built in to VBA to prevent a subform from loading the data when the main form is opened? Presumably to get the subform to update afterwards you'd just refresh / requery the subform on the button click event???
When I do update the data in the subform, I'd like columns 1, 2, 3, 5 and 6 to be fixed at a particular width and column 4 do expand to what ever is available. My thinking is when the mainform loads, I'll get the subform width and subtract the fixed column widths of 1, 2, 3, 5 and 6 before making column 4 width whatever value if left over.
How to you access the subforms column from the mainform? Is there an easier way to do this? I wondered whether you could do this from the subform itself but I'm not sure it could determine it's width on the mainform...
Thanks