By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 920 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Forcing the Count(*) function to update.

P: n/a
I have a text box on the header of a continuous form which has
=Count(*) as its control source. This is probably simple but how do I
make it update the count of records each time I add a record. At the
moment it will only update after closing and reopening the form. I've
tried RepaintObject and Requery but these don't work.

Thanks in advance.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Wayne Aprato" <cq*******@volcanomail.com> wrote in message
news:4d**************************@posting.google.c om...
I have a text box on the header of a continuous form which has
=Count(*) as its control source. This is probably simple but how do I
make it update the count of records each time I add a record. At the
moment it will only update after closing and reopening the form. I've
tried RepaintObject and Requery but these don't work.


In the AfterInsert event of the form...

Me!NameOfControl.Requery
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.