Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2011
    Location
    USA
    Posts
    13

    Question Unanswered: To much effected

    I am doing a quick and easy If, Then, Else Script. what if have is this:

    If Me. DispositionDestination = 1 Then
    Me.Date = N/A
    Me.Date.BackColor = vbRed
    Me.Date.Locked = True
    Else
    Me.Date = " "
    Me.Date.BackColor = vbWhite
    Me.Date.Locked = False
    End If

    Now it works just fine, but it applies itself to the entire column OnClick. I only want it to effect the Field in the same Row. If there is any help that could be provided please let me know how I messed this up

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    don't think you can do this in 'continuous form' mode
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2011
    Location
    USA
    Posts
    13
    So if I created a single form and I had the color change on that form could I have it imported to a continuous form? or could I write code in an actual table to get what I need?

Posting Permissions

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