controlling check boxes with a checkbox 1

[kpryan]

Hi

Would appreciate some help with this please.
I have a continuous form in which I use a check box via conditional formating to change the background of text boxes.
This highlights the record so that the user can see that this record has been edited.
I would like to be able to reset all the records that have been highlighted back to their original state at the same time by using another check box.

Many thanks,

KP

 

[Remou]

What line have you used in conditional formatting for highlighting?

 

[TheAceMan1]

Howdy kpryan . . .

Perhaps this ([blue]you![/blue] substitute proper names in [purple]purple[/purple]):

[blue]   Dim hldID As Long, SQL As String
   
   hldID = Me![[purple][B][I]PrimaryKeyName[/I][/B][/purple]]
   
   SQL = "UPDATE [[purple][B][I]TableName[/I][/B][/purple]] " & _
         "SET [[purple][B][I]CheckboxName[/I][/B][/purple]] = False;"
   CurrentDb.Execute SQL, dbFailOnError
   
   Me.Requery
   Me.Recordset.FindFirst "[[purple][B][I]PrimaryKeyName[/I][/B][/purple]] = " & hldID[/blue]

Note: the code assumes [purple]PrimaryKeyName[/purple] is numeric. If text, changes have to be made accordingly.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[kpryan]

Hi The Aceman1,
You did well!. Many thanks for your help.
Its works well.

By the way where do you get all this time to answer all these queries?

 

[TheAceMan1]

kpryan . . .

I went to be early . . . So I'm up early this mourning!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886