Hello all,
Im trying to code my own navigation record x of y record box. (The navigation button that shows record 1 of X) I turned navigation buttons off and already created the other buttons (add new record, first record previous...etc.), but I'm having trouble creating the box that shows me which record I'm on. A friend helped me by informing
me to create a *label* on my form named lblNavigate then insert this code into my form in OnCurrentEvent .. . .
Private Sub Form_Current()
If Me.NewRecord Then
Me!lblNavigate.Caption = "New Record"
Else
With Me.RecordsetClone
.Bookmark = Me.Bookmark
**** Me!lblNavigate.Caption= "Record "&_
.CurrentRecord _
& " of " & .RecordCount
***
End With
End If
End Sub
When I do this and view my form nothing happens. I have no idea why. Maybe my code is wrong, maybe my friend was wrong when he told me to create a "label" called lblNavigate. The error I receive says "Object doesn't
support this property or method" and in my vb it errors right around where I put stars (***). Im thinking my friend was wrong when he told me to create a label called lblNavigate as opposed to a text box or something...but when I tried this in my text box it said #Name... and not the record number.
Can anyone help me.. Hope this all makes sense...if not I guess from scratch, how do I do this.
Thank you sooooo much!!
Im trying to code my own navigation record x of y record box. (The navigation button that shows record 1 of X) I turned navigation buttons off and already created the other buttons (add new record, first record previous...etc.), but I'm having trouble creating the box that shows me which record I'm on. A friend helped me by informing
me to create a *label* on my form named lblNavigate then insert this code into my form in OnCurrentEvent .. . .
Private Sub Form_Current()
If Me.NewRecord Then
Me!lblNavigate.Caption = "New Record"
Else
With Me.RecordsetClone
.Bookmark = Me.Bookmark
**** Me!lblNavigate.Caption= "Record "&_
.CurrentRecord _
& " of " & .RecordCount
***
End With
End If
End Sub
When I do this and view my form nothing happens. I have no idea why. Maybe my code is wrong, maybe my friend was wrong when he told me to create a "label" called lblNavigate. The error I receive says "Object doesn't
support this property or method" and in my vb it errors right around where I put stars (***). Im thinking my friend was wrong when he told me to create a label called lblNavigate as opposed to a text box or something...but when I tried this in my text box it said #Name... and not the record number.
Can anyone help me.. Hope this all makes sense...if not I guess from scratch, how do I do this.
Thank you sooooo much!!
