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?
Thanks,
Jim
Code:
=IIf([CurrentRecord]>(Count(*)),'New Record',('Record ' & [CurrentRecord] & ' of ' & Count(*)))
Thanks,
Jim