I am working on a form in a database I am working on for a non profit. It is on a tab control. I am trying to conditional format the name of a person based of if they receive services, provide services or both.
tblContacts is pretty standard
FName
MI
LName
Address
City
State
Zip
RecServices (check box)
ProvServices (check box)
I orignally wanted to use the check boxes but the Conditional Formatting doesn't work when both are checked. (e.g. if both fields are checked it formats to RecServices as that is the first formatting option)
I opted to use an option box as there are only three options. tblContact has the field "Services" formatted as text.
Receive Services is set at 1
Provide Services is set at 2
Both is set at 3
I am using the code below to use the Conditional Formatting however there is something not working. Does anyone have a clue?
DLookUp("[LName]","tblContacts","[Services] = 1")
Any help would be greatly appreciated
tblContacts is pretty standard
FName
MI
LName
Address
City
State
Zip
RecServices (check box)
ProvServices (check box)
I orignally wanted to use the check boxes but the Conditional Formatting doesn't work when both are checked. (e.g. if both fields are checked it formats to RecServices as that is the first formatting option)
I opted to use an option box as there are only three options. tblContact has the field "Services" formatted as text.
Receive Services is set at 1
Provide Services is set at 2
Both is set at 3
I am using the code below to use the Conditional Formatting however there is something not working. Does anyone have a clue?
DLookUp("[LName]","tblContacts","[Services] = 1")
Any help would be greatly appreciated