[AccessD] Capture That Record Number

It is simply an ordinal position in the recordset, not a real number.
You can find out what the absolute position of the current record is
when you enter it, but that's all.  When you requery, the order of
records may change, since new records are initially added to the end but
will sort themselves appropriately on a requery.  Why are you requerying
after a delete?

Charlotte Foust


-----Original Message-----
From: Nicholson, Karen [mailto:cyx5 at cdc.gov] 
Sent: Thursday, December 23, 2004 9:10 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Capture That Record Number


That is what I did, but sometimes when I do the requery, then the record
that I change eliminates it from the recordsource and when I tell it to
go to that specific task number, it is not there.  So I thought it would
be nice to go to about the same place as before, or the record after the
one that was deleted.  There must be a place that the navigator bar gets
its count from.

-----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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com