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.

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).]

Thanks, that worked great!!!

Glad I could help... http://www.access-programmers.co.uk/ubb/smile.gif