Consulting

Results 1 to 3 of 3

Thread: the value you entered is not valid for the field

  1. #1
    VBAX Regular
    Joined
    Oct 2017
    Posts
    14
    Location

    the value you entered is not valid for the field

    instructions.JPG
    vendor is short text, i can save the record normally when i select the value from the combo box because my combox is bounded to vendor field. but also i have created a macro for a button which is next to go for other record. but while viewing other records using next button i can view all the data from the master table.
    the issue is if a user wants the value to change from one to another in he combo box then the onchange event triggers and then the value should be updated by old value in the table
    similar like this
    t1.JPG
    t2.JPG
    also i pulled values from that vendor table to combo box.
    Last edited by Rickz; 11-21-2017 at 02:56 PM.

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    The Change should automatically take place without any On Change vba.

  3. #3
    VBAX Regular
    Joined
    Oct 2017
    Posts
    14
    Location
    Thanks OBP, i have figured it out yesterday and resolved it . As i was validating few fields before the save operation has performed thats why it didnt allow me to save automatically.

Tags for this Thread

Posting Permissions

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