Access 2010 Field conditional format on a form from an external table field
Posted on 2014-01-13
I have a Form with a field that I want use a conditional format on, but the condition is in another table is a field for the condition.
Form1 has the field which needs to go to a table that has three fields and match the first field in the table.
When there is a match in the first field in the table, then check the third field in the table for that value= "Y",
IF that is a match then color the field on the form.
I know how to do a conditional format on the field on the form,
its the going to a table lookup to verify the two fields and come back.
I am running Win7 x64 and Access 2010 x86 and the Tables or linked to a SQL backend.
My Table has these fields: dcode, dname, promo.
The form field to put the condition on is called dname
They are all text fields.
Can anyone give me some guidance, I am sure that it is an expression that I need in the Conditional formatting on the field.