-
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.
-
The Change should automatically take place without any On Change vba.
-
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
-
Forum Rules