Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2011
    Posts
    11

    Question Unanswered: Applying code to only 1 record, not entire db.

    Hi, Newbie here.

    I am trying to use code to make a row/record turn bold when a check box is checked. The code goes something like this:
    Private Sub Resolved_Click()

    If Resolved.Value = True Then
    Date_Drawn.FontBold = True

    Else
    Date_Drawn.FontBold = False

    End If

    If Resolved.Value = True Then
    Slip_No.FontBold = True

    Else
    Slip_No.FontBold = False

    End If

    If Resolved.Value = True Then
    Last_Name.FontBold = True

    Else
    Last_Name.FontBold = False

    End If

    ...(for several more)

    It works wonderfully. The problem now, is that when the first checkbox is checked, the bold applies to all of the records in the form instead of just the one it was intended for. I would like to find a way to have the code apply only to the record that includes that particular checkbox.

    Thanks!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    please don't double post
    if you are not gettign a response from your original post, and think it may have been misposted or benefit from moving then bump the post and request it be moved
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2012
    Posts
    16
    Can anyone help with this question as I am also having same sort of problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •