How do i set a conditional formatt on my subform base on the main form value?

[JuanitaSaniThon]

I have a main form that is based on a customer table(Form Name: tblSLA).Each customer has different "CPU SLA %" value.Eg: Customer Name: XYZ and CPU SLA % = 85%.

How do I set a conditional formatting on my subform, if for the month of January,if Customer Name = XYZ and the CPU% is >85% set background as "green" else "red".

You may refer to the attachment for a clearer view.

[copleyuk]

Depending on how you are planning to determine the month i.e is it the current month of the year or a selected month from a list then the answer varies.

However I think if I get what you are asking correctly then the answer should be:

Dim cpumainfrm, cpusubfrm, customername as string

cpumainfrm = me.cpu_asl_%
cpusubfrm = forms!mainform!subform!cpu%
 
customername = me.customername
 
 
If cpumainfrm > cpusubfrm then forms!mainform!subform!.form.detail = 124512 Else forms!mainform!subform!.form.detail = 454212

You will need to enter your correct form names in place of the mainform! and subform! and select your own colours.

Hope this does the trick for you.