Change button color after data change

[torquay]

Can someone please point me in the correct direction
I am trying to change the button color on a subform if a related form data changes
Main form is products with a continuous subform with serial numbers of products i.e, serial number, location, price and a button to add addtional issues if there are any for this particular serial number (this will open up another form related to the serial number so I can add an issues if there are any)
The reason I would like the button to be a different color is so I can quickly see if there are any additional notes been added to the serial number.
Just in case you may ask why not add the field to the continuos form is that the issues and be quite lengthy and there may be lots of serial numbers on the form


2346 location warehouse price £29.99 (button - green)
2347 location shop price £29.99 (button - red)

Thank you

 

[Isskint]

In the afterupdate event of the control (controls) you want to monitor (eg the one whose data could change) add code along the lines of

Me.[Subformname].Form!CommandButtonName.Backcolor = ?????