xena_morph
03-20-2002, 04:40 PM
i have a form set up which runs from a query, waht i would like to do is show on the form a box indicating how many records were found matching the search criteria, and at what record amonngst those matched you are at i.e. record 4 of 12.
ive already set up the next record and previous record its just the above i need at the mo
thanks
Jack Cowley
03-20-2002, 05:29 PM
http://www.mvps.org/access/forms/frm0026.htm
xena_morph
03-21-2002, 10:11 AM
hi
ive tried putting that code in:
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
but run into trouble because i dont know why i need to put a label on it, should i not be putting a text box in it or something, also can you tell me if it the label was for example called recordnumber what the coding would look like
many thanks