How do you retrieve the record number in Access?

[Loein]

I need to be able to retrieve the current record number
in a form. Does anyone know what the command is? I have
worked extensively in DBX where I was able to retrieve
the current record number. Does anyone know if there is
an equivelant command in Access?

 

[Geof Wyght]

This is from Access Help under the CurrentRecord property:
Dim lngrecordnum As Long
lngrecordnum = frm.CurrentRecord

You could have this in your Form_Current procedure.
Geof.

 

[Albert D. Kallal]

You might want to read the following:

http://members.iinet.net.au/~allenbrowne/tips.html#xbase

And, more importantly...read the following lists of tips..and pay attention
to #7

http://www.mvps.org/access/tencommandments.htm