I tried Micron’s code, but I’m stuck on the Tag property. Do I enter it in the property sheet for each control I need to be filled in? I’ve never used the Tag property before, so I looked it up, and all the examples I found showed setting it with code. However, none showed where the code goes, e.g. the before update event on the form or an event on the actual control.
Also I’m unclear about,
“reqd,message 4 and more text Note that it is reqd and then a comma and
then text with no spaces until the message.”
I get “reqd,” but is the word “message” followed by my actual message or does something go before the message? “4 and more text, and.” text with no spaces until the message suggests that there is, but what comes before “Please enter a sample number,” etc.
I also tried missinglinq’s suggestion of adding Exit Sub inside of each If statement. When I tested it by first removing the values in the table, saving the table and then going back to the form and trying to save the record or go to the next record, nothing happened. It did work if I first put the cursor in the text box or the combo box, but the problem is that users are apt to skip the control and never put the cursor there.
Also I’m unclear about,
“reqd,message 4 and more text Note that it is reqd and then a comma and
then text with no spaces until the message.”
I get “reqd,” but is the word “message” followed by my actual message or does something go before the message? “4 and more text, and.” text with no spaces until the message suggests that there is, but what comes before “Please enter a sample number,” etc.
I also tried missinglinq’s suggestion of adding Exit Sub inside of each If statement. When I tested it by first removing the values in the table, saving the table and then going back to the form and trying to save the record or go to the next record, nothing happened. It did work if I first put the cursor in the text box or the combo box, but the problem is that users are apt to skip the control and never put the cursor there.