Ok i have searched through the forums but can't find anything that is specific to my problem.
On my database I have a main screen, that has several option buttons on it, and asubform for the main data entry.
On the main screen I have a text box that is bound to a query that counts a total of entries for the day, the query works fine and the form will show the total in the box, when it is loaded.
However I need the box to update itself to keep a running total, for the users to see how many entries have gone in that day.
Currently I have a on timer event as follows :
Me.txtcount.requery (where txtcount is the field showing the total)
If I add the line "DoCmd.ShowallRecords", then the number in the text box refreshes itself but so does the entry form, which can be a pain for a user halfway through entering data.
How can I get the field to update itself, do I have to re-run the query as well as refresh the text box ?
Many thanks
MattP
On my database I have a main screen, that has several option buttons on it, and asubform for the main data entry.
On the main screen I have a text box that is bound to a query that counts a total of entries for the day, the query works fine and the form will show the total in the box, when it is loaded.
However I need the box to update itself to keep a running total, for the users to see how many entries have gone in that day.
Currently I have a on timer event as follows :
Me.txtcount.requery (where txtcount is the field showing the total)
If I add the line "DoCmd.ShowallRecords", then the number in the text box refreshes itself but so does the entry form, which can be a pain for a user halfway through entering data.
How can I get the field to update itself, do I have to re-run the query as well as refresh the text box ?
Many thanks
MattP
