Yoshi88
05-08-2001, 09:26 PM
I dont want to use the navigation bar in a form, but I want the user to know how many record there is and on wich he is working on. I create an unbound text box with this code in the control source.
=[CurrentRecord] & " of " & Count(*)
Its working well, but if I add a new record the "of y" section doesn't uptdate. I tried many thing like after update, a requery, ... but it never work. The only way to refresh it is to close the form and to open it again. Does anyone has any idea.
François
=[CurrentRecord] & " of " & Count(*)
Its working well, but if I add a new record the "of y" section doesn't uptdate. I tried many thing like after update, a requery, ... but it never work. The only way to refresh it is to close the form and to open it again. Does anyone has any idea.
François