[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