Access conditional formatting based on unbound combobox
Posted on 2012-08-21
I have an access form with a subform that's a datasheet.
On the main form, there is a combobox which I use to change views. Changing the combobox changes which records show in the datasheet subform (by using VBA to change the SQL).
I also have conditional formatting in the subform, to change the color of certain records.
Here's what I'm trying to do, and can't figure out how:
My users want me to set the conditional formatting logic so that when the combobox on the main form is set to a certain value, different records get their color changed.
I've set up the logic in the conditional formatting box, but it does not work properly. I also noticed that it treats the name of the combobox like a field (by putting brackets around it) - maybe that's the problem?
I know my logic is okay, because I tried it out in the immediate window.
Am I doing something wrong?
Here is my expression in case it helps
([TicklerDate]>Date()) Or (([Location]<>getuser()) And ([me].[parent].[filtercombo]=8))