Record Selector

J

jones67

Hello,
I'm building a small data base with a front-end and backend and was
wondering how to code my own record selectors, code a textbox to show the
current record, and another textbox to show the total records.

jones67
 
F

freakazeud

Hi,
this is not that hard...to duplicate the record x of y you can use the
following code on the on current event of the form:

If Me.NewRecord Then
Me.YourLabel.Caption = "New Record"
Else
With Me.RecordsetClone
.Bookmark = Me.Bookmark
Me.YourLabel.Caption = "Record " & _
.AbsolutePosition + 1 _
& " of " & .RecordCount
End With
End If

The command button wizard should be able to help you with the controls. You
might also want to look at these:
http://www.applecore99.com/frm/frm033.asp
http://www.fmsinc.com/tpapers/cstmbtn/
HTH
Good luck
 
Top