Count records dynamically in a form

[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

 

[Guest]

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.

 

[Steve Schapel]

Silvio,

Try putting this on the After Update event of the form...
Me.Recalc