After pressing the button to open a query on the main menu I change the colour of the forground of the button to reset the query to the original query (see my last post). Now I would like to hold this foreground colour, but it is lost as soon as I leave this form and go back to it. I tried to keep it as a global variable, but it doesn't work for a single variable. Has one of you a solution for this? Thanks in advance!

If you want it to be there when you come back, you'll need to store it somewhere. I would suggest storing it in a table and retrieving it with a DLookup when you need it. That way it will also still be there if you close the db and reopen it.

Thanks Bob. This indeed gives the reminder that the query has been changed (at least opened) in the previous session after the database is restarted.