Conditional formatting expression

[SunTop]

Hello Everyone
I have a Text Box control on my form that I want to apply conditional formatting to. The problem I am facing is that, when I am writing the conditional formatting expression and I refer to a field in a table or a query outside my form, the conditional formatting is not applied, but when I refer to a control on my form, the conditional formatting works fine. What am I doing wrong here ?

[JoeM]

How exactly are you trying to reference fields that are not on your Form?
What is your Conditional Formatting formula?
Why not just add the field you need in the Query that your Form is based on?

[SunTop]

Thanks for your reply JoeM

I am using this expression on the conditional formatting of a Text Box control on my form [WorkOrders]![ExpiryDate] < Date(). I don't want to put the ExpiryDate field in the underlying query of my form because I want to get unique values of another field (through setting the unique values property in the query properties) and if I put the expiry date then I will not get unique values.

[JoeM]

Since the field is not part of the Record Source of the Form, you cannot call it like that.
Have you tried using the DLOOKUP function to bring that value into your Form?
I have seen people use that method with Conditional Formatting to get fields that are not part of their Record Source.