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

Jim Lawrence accessd at shaw.ca
Tue Jan 4 02:24:47 CST 2005


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




More information about the AccessD mailing list