update forms color change

[trevor40]

For my next question, i have a form to select colors for various areas of my menu system, this is opened from a tab page, it returns the #'s for the colors and another button runs a query to replace the old values, this all works ok. What i need to do is refresh the menu and any color changes made. I think I have to requery any/all controls on the menu sytem that use these colors, or close then reopen the menu. Unless somebody can think of an easier way.

[amrut]

the form's current event should do the trick. You will need to loop through all the controls and set the required color.

[trevor40]

thanks for the reply, I am currently using .requery for all the fields that require an update, there's only 14 at the moment, but it's over 5 different forms. probably best to stay with this as it only changes 14 fields directly, rather than looping through 5 forms and 100's of controls.