I have this code
Code:
Private Sub Form_Current()
Dim rst As DAO.Recordset
Dim lngCount As Long
Set rst = Me.RecordsetClone
With rst
lngCount = RecordsetClone
If lngCount > 0 Then
.MoveFirst
.MoveLast
lngCount = .RecordCount
End If
End With
Me.Text241 = "Record " & Me.CurrentRecord & " of " & lngCount
End Sub
And The idea is that "Text241" is a textbox at the bottom of the form with 2 buttons either side of it eg Go to first, go to prev, go to next , go to last.
and what i want displayed in the textbox is " Record X of Y" X being the record number and Y being the total number of records.
what am I doing wrong?
Thank You In Advance!