Displaying record number

[Guest]

I think I actually asked the wrong question before. What I REALLY want to do
is to display the current record number on internal forms so that I can go to
it quickly. How do I do this

 

[Arvin Meyer [MVP]]

Are you talking about printed forms? You can display the Key in a textbox,
then use a filter to get to it quickly. As for as the record number goes,
that's totally meaningless. Record number 1 when sorted A-Z will be the last
record when sorted Z-A.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Joseph Meehan]

I think I actually asked the wrong question before. What I REALLY
want to do is to display the current record number on internal forms
so that I can go to it quickly. How do I do this

What is record number? Access does not have record numbers, unless you
add them as a field in the table. You should be able to display any record
you want.

Sorry I did not see your prior question so this may not be useful
information for you.

 

[JK]

Boyd,

Further to What Arvin says, if you want to leave a record and come back to
it, you can do it asf:

+++++++++
Private Sub(ComeBackToMe)

Dim curRec as long ' Current Record Number

curRec=Me.Form.CurrenRecord
.....
' do something in other records
......
DoCmd.GoToRecord , , acGoTo, curRec

End Sub
++++++

Hope that is answer your question.

Regards/JK

 

[JK]

Sorry, typo above

Correction

Private Sub(ComeBackToMe)

Dim curRec as long ' Current Record Number

curRec=Me.Form.CurrentRecord
.....
' do something in other records
......
DoCmd.GoToRecord , , acGoTo, curRec

End Sub


Regards/JK