@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...