Robert Gracie
Subscriptions at servicexp.com
Tue Jan 4 13:13:10 CST 2005
Gustav, Thanks, Works like a charm !! At least this way, it's only the Form(s) in question that are not being repainted rather then the entire application with the use of docmd.echo.. Robert Gracie -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Tuesday, January 04, 2005 12:56 PM 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