Custom Record Box - Displaying Record x of x

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Simple one I hope. I don't like the position of the little navigation bar and record box at the bottom of the form and want to add my own. The navigation buttons are easy. I can even do the total records with the =Count([IDPartNo]) in a text box. Question is, what is the syntax for displaying the number of the current record. You know, like if the table has 50 records and I am on record 25 on my form, I would like to put on the form somewhere, "Displaying Record 25 of 50. Any help is much appreciated. Thanks.
 
Use a label named LblRecord beside your custom buttons and put the following
code in the OnCurrent event of the form:

Me!LblRecord.Caption = Me.RecordCount & " Of " & Count([IDPartNo])

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com



MBoozer said:
Simple one I hope. I don't like the position of the little navigation bar and
Click to expand...
record box at the bottom of the form and want to add my own. The navigation
buttons are easy. I can even do the total records with the =Count([IDPartNo]) in
a text box. Question is, what is the syntax for displaying the number of the
current record. You know, like if the table has 50 records and I am on record 25
on my form, I would like to put on the form somewhere, "Displaying Record 25 of
50. Any help is much appreciated. Thanks.
 
Back
Top