How to get record count to update as records are added

[jereece]

I have a form that I want to show "Record _ of __". I am using the code below in the Control Source of a text field. My question is how do I get it to update as I add records?

=IIf([CurrentRecord]>(Count(*)),'New Record',('Record ' & [CurrentRecord] & ' of ' & Count(*)))

Thanks,
Jim

 

[Pat Hartman]

This functionality is built in to Access. Just use the navigation bar and you don't need code.

 

[jwhite]

Add 'Record x of y' count on a form (navigation)