[AccessD] Capture That Record Number

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






More information about the AccessD mailing list