Search results

Hi guys, I've always wanted to be a part of this community but never found the time. I've been primarily working on MS Access Applications for the last 2.5 years. I hope that I can help someone in need. I work in Hastings New Zealand for a small software company called ProcessIT. I have been...

Hi andy1968 I think you need to do your re-query in the after update event not the current event of the subform. Current will, like you said, fire when the form opens as well as when the data changes. After Update will fire only once a record has been altered or created. I hope this helps

The Solution that I would use in this situation would be to simply create a Form_Resize() event and insert what stevenblanc mentioned: If Me.InsideHeight < 5000 Then Me.InsideHeight = 5000 If Me.InsideWidth < 5000 Then Me.InsideWidth = 5000 Where the '5000' indicates the minimum size you wan...