Changing color on the screen

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I have a form that used to be a standalone where the user selected the
event to be modified and based on that, I changed the color of the
screen. That works fine.

Now the users have requested to make the form only available through
another screen (users click a button, which calls a macro to open the
other screen.) I'm not sure under what event to put the code for
colors in this scenario. Could someone help me out?

Thanks

Jeff
 
Jeff said:
I have a form that used to be a standalone where the user selected the
event to be modified and based on that, I changed the color of the
screen. That works fine.

Now the users have requested to make the form only available through
another screen (users click a button, which calls a macro to open the
other screen.) I'm not sure under what event to put the code for
colors in this scenario. Could someone help me out?
Click to expand...
The event would be in the screen you want to change color.
I'm not sure which that is but if the original, the one that was a
standalone, it would remain in the same place.
 
Sorry I wasn't clearer.

I'm interested in which event to place the color code in.

Would it be on Open (or does that mess w/ the macro)?

Or On Current, On Load or Before Update or some other one?

Thanks

Jeff
 
Jeff said:
Sorry I wasn't clearer.

I'm interested in which event to place the color code in.

Would it be on Open (or does that mess w/ the macro)?

Or On Current, On Load or Before Update or some other one?

Thanks
Click to expand...

Anything other than before update is not needed as you could just open the
form in the color you want.
You could check the .dirty property in Before Update but then it would have
to be changed back for the next record.

When and under what circumstances do you want to change the color.
And what happens if somebody Changes "A" to "B", then back to "A"
 
Back
Top