Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2009
    Posts
    16

    Unanswered: List Box value based on text box input

    I have a score text box that allows inputs from 0 to 100 and a pass/fail list box with values pass and fail as options.
    what i want is for when the score is put in, if the score is 70 or less for the pass/fail list box to select fail otherwise select pass.
    this will save the data entry person from selecting that field every time.

    thanks

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    In the after update event of the textbox:

    Code:
    If Me.TextboxName > 70 Then
      Me.ListBoxName = "Pass"
    Else
      Me.ListBoxName = "Fail"
    End If
    Paul

  3. #3
    Join Date
    Jul 2009
    Posts
    16
    this also isnt working,
    here is what i have

    Private Sub QCScore_AfterUpdate()
    If Me.QCScore > 70 Then
    Me.QCPassFail = "Pass"
    Else
    Me.QCPassFail = "Fail"
    End If
    End Sub

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Again, what does "not working" mean?
    Paul

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    why do you need to store a value AND a text
    one begats the other......
    you can alwaasy recreate the pass/fail in a query
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Jul 2009
    Posts
    16
    Quote Originally Posted by pbaldy
    Again, what does "not working" mean?
    it means that it does not update the other field like i would like it to.

  7. #7
    Join Date
    Jul 2009
    Posts
    16
    works now thanks

Posting Permissions

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