Custom Record Box - Displaying Record x of x

[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.

 

[PC Datasheet]

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

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.

 

[Guest]

Thanks a mil!