Is it possible to conditionally format a control on a form based on value in a query that isn't linked in the control source? I want a name to change color in one form if the person is away on a trip based on records from another table.
Reply from Alex Hedley:
You could try using a DLOOKUP in your Expression to get a value from another Table/Query and check that against your condition
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 19.
