single record manipulation

[Hsibbs]

I have a table with over 2000 records, the user enters and updates on this table via a form. At some stage, when the record is fully paid or no longer current, I would like a button on the form to 'disable' this record, ie grey it out so the user know it is 'done'. they should also be ab;e to 'turn it back on', just on case..............

Any ideas on how to do this?????

 

[Hsibbs]

Aha!!!!!

perfect!!

Thank you!


I've decided to change the back color of the detail part of the form to grey.

How do I do that in vb???

 

[VicRauch]

Private Sub Detail_Click()
  If Me.Detail.BackColor = -2147483633 Then
    Me.Detail.BackColor = 12632256
  Else
    Me.Detail.BackColor = -2147483633
  End If
End Sub

This code will change the Detail background of a form from the default color (-2147483633) to gray (12632256), or from gray to the default color. Just click on the detail part of the form. (You can not click on any of the controls on the form, it must be background area you click on)
HTH,