Conditional formatting - from another table

[Gismo]

Hi,

i need to highlight a control if a value is met from another table
i used expression:# [DAW Sheet Data File]![Raise CS Order]=2#
but does not highlight.
any reason why?

 

[Gasman]

Just how is CF meant to be able to look into a table?, for what particular record?

Bring the data into the form, then address that control in the CF rule.

 

[Deleted member 147267]

It is possible with DLookup but I agree - bring the data into the form. If more than one record could satisfy the DLookup function then the value returned by it would be random.
EDIT - BTW, not only might multiple records satisfy the lookup, the criteria probably needs to be based on a form field on the current record. If not, the DLookup return will be constant for every record; i.e. if it is true at all, it will be true for any record on the form.

 

[Gismo]

didnt think this one through
works fine

another question on conditional formatting

is it possible to have conditional formatting to display a text if a pertain value is met?

 

[Deleted member 147267]

Depends on what you mean by that. Display a text in some control if a format is applied to some control? If using the conditional format dialogs I'd say no, unless someone can come up with an expression that would work. I can't think of one at the moment. If you wanted to do it all in code, then should be doable if you test a format property and then set the value accordingly, but you seem to be going about things in a very odd way.

 

[MajP]

You only need conditional formatting if the form is in continuous view. This can be done simply by code if single form view.

 

[Deleted member 147267]

NEVER use dLookup() in queries.

Is that just general advice or was that suggested or being used here? If so. I missed it.

 

[June7]

Conditionally display text with expression in textbox ControlSource. Use IIf(), Switch(), or Choose().

 

[Deleted member 147267]

@Pat, I know that. Can you show me where it was posted here that a DLookup was in a query? I don't think you can, which is why I asked if your comment was general in nature or if it was stated, then I missed it, hence I asked that question.