Charlotte Foust
cfoust at infostatsystems.com
Tue Jan 4 15:01:00 CST 2005
But in some situations Painting doesn't work, like on subforms and parent forms. In that case Echo is the only way to turn off screen painting while you do whatever needs to be done. Charlotte Foust -----Original Message----- From: Gustav Brock [mailto:Gustav at cactus.dk] Sent: Tuesday, January 04, 2005 9:56 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Recalc Parent with out loosing place in subform? Hi Robert DoCmd.Echo is nasty. Try this: With Me .Dirty = False ' Must force a save in order to grab bookmark NewBookMark = .Bookmark ' Grab the current position .Painting = False ' Turn form update off to hide flicker from recalc .ReCalc .Bookmark = NewBookMark ' Move to saved bookmark .txtType.SetFocus ' Force movement to next logical field .Painting = True ' Repaint form End With /gustav >>> Subscriptions at servicexp.com 04-01-2005 18:36:49 >>> Jim, Thanks for the suggest, clever!! I was able to control my field position with the code below.. Not very elegant but it works.. With Me .Dirty = False ' must force a save in order to grab bookmark NewBookMark = .Bookmark ' Grab the current position DoCmd.Echo False 'turn screen update off to hide flicker from recalc .ReCalc .Bookmark = NewBookMark ' Move to saved bookmark .txtType.SetFocus ' force movement to next logical field DoCmd.Echo True ' turn screen update back on End With Thanks to everyone!! Robert Gracie -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com