Hi, I have a form with a subform which has vba to resize when open. I use a dropdown menu to change the source of the subform using source object in vba but when i do this the subform changes size and is too small. Has anyone got any advice on how to resize the subform after changing the source of the subform?