conditional formatting format

[Jcwishart]

Hi,

I am trying to place some code in the "expression is" section of conditional formatting. Need some help converting from code to conditional formatting format.

I have set up a check box "Check83" next to a standard control box "Title(O)".
Below is the code I am currently using. This code is in the after update section of the check box, and in the oncurrent section of the form.

This code turns the box blue when I click the check box.

Private Sub Check83_AfterUpdate()
If Me.Check83 Then
Me.[Title(O)].BackColor = vbBlue
Else
Me.[Title(O)].BackColor = vbWhite
End If
End Sub

My form has 46 records and all have check boxes linked to the control box with the code above. When the box is blue in record 1, I don't want there to be a blue box in record 2. Can't figure out how to do this. Tried to do in with code, but failed. Thought it may be possible using conditional formatting.

Thanks in advance for your help

Jcwishart

 

[CEH]

Looks like you just forgot one value....

Try.....

If Me.Check83.value = True Then
Me.[Title(O)].BackColor = vbBlue
Else
Me.[Title(O)].BackColor = vbWhite
End If

 

[Jcwishart]

Both codes work...what I'm trying to do is create an event in one record using [Title(O)] and the check box, but when I select record 2, the [Title(O)] box is clear. It has been suggested that I bound the check box to my table, which I did, but now I can't use the check box in the form!
Any ideas?

 

[Jcwishart]

this is another task I am working on:
I think this might work, but I'm not sure how to execute it.
Not sure if I can do this in the conditional formatting.

All the assigned dates can be placed in the table I am using under the field [CDs1]

Record 1....due date....04/04/2006.....control box=[CDs1]
Record 2....due date...04/25/2006......control box=[CDs1]
.
.
Record 46...due date...04/15/2006.....control box=[CDs1]

In conditional formatting how would I do:

Default color white
Field value is…..greater than….record1/row1---date in [CD1]
Or expression is …..greater than….record1/row1---date in [CD1]

Then when I go to record 2 and select conditional formatting in [CD1] I can input
Field value is…..greater than….record2/row2---date in [CD1]
Or expression is …..greater than….record2/row2---date in [CD1]

Is this even possible in conditional formatting?
Or do I need to add some code?
If I do, please help with code and where to put it.

Thanks in advance for all your help!!!

J