CurrentRecord Property

  • Thread starter Thread starter Sredo
  • Start date Start date
S

Sredo

I'm trying to display current record number on a form, but
it does only for first one, even though record content is
corretlly shown. Notice: I'm doing it using VBA and DAO
features from Access 2002 ( Table recordset).
If someone like to discover that secret to me I'll say to
them: Great Thanks.
 
Sredo said:
I'm trying to display current record number on a form, but
it does only for first one, even though record content is
corretlly shown. Notice: I'm doing it using VBA and DAO
features from Access 2002 ( Table recordset).
Click to expand...


What do you mean by "current record number"?

If you mean the number of the record in the form's record
source, then you can use Me.CurrentRecord in VBA. In a text
box on the form, you can use the expression:
=Form.CurrentRecord
 
Sredo said:
I'm trying to display current record number on a form, but
it does only for first one, even though record content is
corretlly shown. Notice: I'm doing it using VBA and DAO
features from Access 2002 ( Table recordset).
If someone like to discover that secret to me I'll say to
them: Great Thanks.
Click to expand...

Without seeing any code, we are simply quessing although..

It sounds like your control is not updating when you move to a new record.
Try this code in your forms OnCurrent Event

Private Sub Form_Current()
Me.YourControlName = Me.CurrentRecord
End Sub
 
Back
Top