conditional formatting on combo box

[hwr]

Hi,

I want to add a conditional formatting to a combo box to highlight if the value is not on the list.

There is a process to read in data from a 3rd party excel sheet that has truck arrival dates and times. My form displays this data and allows the internal users to change it. My form has the "Trucks" field as a limit to list combo box - so basically any data can be read into this field but internal we can only change it to trucks on the list (from the trucks table). I want to highlight where the trucks value is not in our trucks list.

Hope someone can help.

Thanks
HWR

 

[CJ_London]

there are a couple of ways this can be done, but which is right for you depends on what you have for truck names.

The simplest way is probably to use the dlookup function

field value is ... not equal to ...dlookup([cboName],"tblTrucks","truckName='" & [cboName] & "'")

 

[hwr]

Thanks!!
The dlookup was exactly what I needed. I got it to work using Expression is... IsNull(DLookUp("[TruckName]","Trucks","TruckNo='" & [cboTruckName] & "'"))

Your help is very much appreciated.