Robert Gracie
Subscriptions at servicexp.com
Tue Jan 4 11:36:49 CST 2005
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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Tuesday, January 04, 2005 3:25 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Recalc Parent with out loosing place in subform? Hi Robert: You could use something similar as the following to save then move to a specific record on a subform: DoCmd.GoToRecord acDataForm, "TheSubFormName", acGoTo, intCurrentRecords Just save the current subform record position, in a variable (intCurrentRecords), refresh, then apply the above line of code to reposition yourself to the correct data row. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Gracie Sent: Monday, January 03, 2005 9:16 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Recalc Parent with out loosing place in subform? Hello, This seems so silly, but I can't figure out how to cause the parent form (from with in the subform) to recalc WITH OUT causing the subform to requery, and move the cursor back to the top record. Any ideas?? Or is this not possible?? 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