Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010
    Posts
    4

    Unanswered: Help getting field to return value

    I have a field that holds the value gross weight. What I need to have in another field is a letter value based on gross weight. Example if gross weight <= 55000 then I need a category field to show A else if gross weight >= 55001 and <= 56000 then show B and etc. up to letter V. I actually have the field working only it does not put the letter value in the field until you go to the next record and then come back. I would like the category field to update after entering the gross weight amount.

    On the Event tab I am using On change for the gross weight field.

    Any suggestions to get this field to update without going to next record and then coming back to see change?

  2. #2
    Join Date
    Aug 2009
    Location
    Up Nort' Wi
    Posts
    140
    I use this same technique for some of my text boxes. Make sure that within the _Change() event you are calling the .Text property. i.e. txt_grsWght.Text

    Otherwise it doesn't actually see the input until the field is updated.

    Sam, hth
    Good, fast, cheap...Pick 2.

  3. #3
    Join Date
    Mar 2010
    Posts
    4
    Thank you for the tip. That was to simple and now the form works like I wanted it to.

Posting Permissions

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