Count records dynamically in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello fox, how do I dynamically display the total of records as I enter new
ones using a form ? I have a form with an unbound text box with record source
=Count(*) the problem is that it does not update the total as I enter new
records. It appears to me that it is a refresh issue. I have tried to use
me!refresh on exit, lost focus etc. but it does not appear to work, Any
suggestion?

Thank you,
Silvio
 
Have you tried putting the field into the form footer or header? Then set it
to Count([fieldname]). that way when the field is changed as you add the
record, the count will be updated.

Enjoy. j.
 
Back
Top