conditional formatting

[Jim W]

I have 2 subforms on a main form. I would like to compare the value in field 1 og subform 1 to field 1 of subform 2. I can't seem to get the conditional foramtting between the 2 subforms to work. Any ideas?

Jim

 

[krunalprajapati]

u can use
if Forms![MainFormName]![SubForm1name].Form.[fieldname] =
Forms![MainFormName]![SubForm2name].Form.[fieldname] then

(statements....)
endif