I want to create my own navigation buttons along with a control that will tell the user what the current record number is. For example record 2 of 10. I can create the total number of records but i can not finger out how to calculate the current record number. My form is based on a query. Any help would be greatly appreciated.
calculate current record number
- Thread starter AnnPhil
- Start date
If I am understanding your question and I think I am...
You can create an unbound textbox on your form...
Then place the following code in the Control Source for the unbound field...
=[CurrentRecord] & " of " & Count(*)
I Hope This Helps...
Don
Edited because I Fat Fingered Something...(aka Typo'd Something)
[This message has been edited by donbettis (edited 01-04-2002).]
You can create an unbound textbox on your form...
Then place the following code in the Control Source for the unbound field...
=[CurrentRecord] & " of " & Count(*)
I Hope This Helps...
Don
Edited because I Fat Fingered Something...(aka Typo'd Something)
[This message has been edited by donbettis (edited 01-04-2002).]
