[AccessD] Recalc Parent with out loosing place in subform?

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



More information about the AccessD mailing list