John W. Colby
jwcolby at colbyconsulting.com
Thu Dec 23 11:00:03 CST 2004
Yea, presto. Of course in a continuous form the record isn't going to be positioned the same but hey... Works exactly as described for single form. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Thursday, December 23, 2004 11:48 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Capture That Record Number You don't. Access doesn't use record numbers in the sense that dBase does. It uses unique keys and the record "numbers" are just position indicators within the recordset. Those numbers can change after a requery. Instead, capture the unique key for that record and store it in a variable. Then find that key again in the form's recordsetclone after the requery and set the form's bookmark to the recordsetclone's bookmark. Hey, presto. Charlotte Foust -----Original Message----- From: Nicholson, Karen [mailto:cyx5 at cdc.gov] Sent: Thursday, December 23, 2004 8:41 AM To: accessd at databaseadvisors.com Subject: [AccessD] Capture That Record Number I am an active puppy today. How do you catch the record number on a continuous form so one can return to that record number after a requery is done? I can see only the higher minds are working today. -- 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