Robert Gracie
Subscriptions at servicexp.com
Tue Jan 4 19:30:05 CST 2005
Charlotte, Turning Painting off worked for me. I'm using it inside a subform (datasheet) ... I think I was also able to turn the parent off from within the subform (datasheet). Robert Gracie -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, January 04, 2005 4:01 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Recalc Parent with out loosing place in subform? 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com