Displaying current record number on a form

[Chris South]

Hi Guys,

I have a form which is set to 'continuous forms' with a form footer. In the form footer I have record number fields ie 'Record 1 of 234'. On all my other forms this works by setting the current record source to =(CurrentRecord), however this doesn't seem to work with continuous forms. I prefer to do it this way rather than use the Microsoft navigation bar. However, can this be done easily when you have continuous forms? doing it my way the current record is always 1.

Any help would be much appreciated.

Regards

Chris South

 

[RichO]

The only way I have found to do this is to have the records autonumbered as they are entered into the table, where actual record number is stored as a separate field.

You would think there would be an easier way...

 

[Rich]

Private Sub Form_Current()
Me.txtCurrRec = Form.CurrentRecord
Me.txtTotalRecs = Form.RecordsetClone.RecordCount + IIf(Form.NewRecord, 1, 0) & " " & "(filtered)"
End Sub