Hold foregrounud colour (1 Viewer)

[Vulcan1500]

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!

 

[boblarson]

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.

 

[Vulcan1500]

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.