Search results

@isladogs You are correct in that I have a form with 3 subforms, each of which I am resizing on load & unresizing on close. The 3 combos are used to change the source object on the subforms dependant on year, factory or owner. Basically, I want to analyse the quantity or value per customer month...

@isladogs Thanks for the advice. I've gone through a lot of the tutorials and updated the code so it works perfect when I open the form. However it still has the same issue when I update the source object as the attachment. What's really strange is that if I open the navigation pane then the...

Sorry, I found this '--------------------------------------------------------------------------------------- ' Procedure : ReSizeForm ' DateTime : 27/01/2003 ' Author : Jamie Czernik ' Purpose : Routine should be called on a form's onOpen or onLoad event. 'Modifications: Jeff Blumson /...

I'm using the below code so not sure where it comes from. Private Sub Form_Load() DoCmd.Maximize Application.Echo False 'auto resize form ReSizeForm Me 'use the line below ONLY if its not included in the subform itself 'ReSizeForm JKTPRODSHIP.Form...

If I remove the resize subform code then it appears as when I change the source object and doesn't fill the subform as the attached screenshot. Somehow I need to resize the subform again but if I use the same code then it doesn't do the same resizing.

I'm using 3 subforms. The on load vba is below. Private Sub Form_Load() DoCmd.Maximize 'auto resize form ReSizeForm Me 'use the line below ONLY if its not included in the subform itself ReSizeForm SUBFORM1.Form ReSizeForm SUBFORM2.Form ReSizeForm...

I resize the subform with the on load property of the main form as below. ReSizeForm SUBFORM.Form When I change thesubform source object then it shrinks back to the original size. When I try to to use the resize vba again then it covers part of the screen and doesn't fit into the subform as the...

Hi, I use a dropdown on a main form to change the source object of a subform. When I use the dropdown then the subform changes the sizing and goes smaller. I use a resize form code when opening the main form but then it changes when I change the source object. Anyone got any advice on how to...