A
adsl
Arvin Meyer said:To add to my post, the record navigator does not display the key number,
except coincidentally. It displays the count and position of the record in
that recordset (usually the form's recordsetclone) So, if you based your
form on a query that selected a subset of records, the numbers would be
different from the Primary Key index that you now have. Using the
recordset.findfirst method you can type in a number and retrieve that
record.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access