Current record position and total records in a form

[imendi]

Hello,

I have a form with the recordsource = table1

Now, I want to add a textbox that shows in what record the user is and the total number of records, something like "Record 4 of 34"
And I don´t want to use the default Navigation buttons that come with the form.
It should update everytime the user moves to the next record, obviously.

How could I do that?

Thanks,

imendi

 

[BH]

imendi

How about setting up another field in your table called record number and then use this to count your records.

On your form you could have Textbox name "Record" in the text box would be the record number then another Textbox with the name "Of" and in this text box the sum of all records.

Just an idea!

BH

 

[imendi]

Hi BH,

Thanks for the idea, but it is not valid, as if I delete a record I will have wrong numbers:
TABLE1

RecordNo Employee
1 Thomas
2 Harry
3 John

If I delete in the form harry, John will still display record number 3, and it is 2 instead.

However, I am using tables I can change anyway.

But thanks for the idea.

imendi