Hi and thanks for your input, much appreciated. I may have to look at this in a different way, if I can explain. The database is for vehicle maintenance etc, on the main form, which is a continuous form uses a navigation form to open up various other forms to add/edit data, one of which is for tests, roadtax, MOT etc, when the new date is entered, the form is closed and the main form is re-queried to reflect the changes made. Query6 looks for every test etc that is out of date and a piece of code loads that query count into a label on the main screen in a marquee fashion to show and highlight that fact that this amount of tests are overdue. it is this piece of code that I would like to run every time I re-query the main form, hopefully that makes more sense.