again, if the answer doesn't matter, why ask the question? I mention this because you do not want to train the users to simply blow by your warnings/questions. Don't bother them if you don't want them to pay attention. Wait until the point in time when the data will be available if it is relevant. If you can't tell by the part number if it needs a license or not, are you just guessing?
In order to have a coherent process, you need consistent rules. If management doesn't give them to you, you need to dig them out or get management to change the process.
I am asking the question because I was told to ask the question. And the answer DOES matter. A NO answer matters just as much as a YES answer. I just respond differently.
" ... get management to change the process." I don't know about your management but mine is not in the habit of of letting low level hourly employees dictate policy and procedures. Heck I have been fighting for months to et them to spend a few hundred bucks to run hardwired network to my area instead of forcing me to use Wi-Fi. (I know. Access and Wi-Fi is a bad mix asking for trouble. I have no other option.)
You are trying to get me to bend to your way of doing something only because you think it is the "right" way to do it. Doing that is ignoring one of the virtues of using Access. It is a flexible program for a reason. You seem to think everything is black and white with no gray in between. That is not the case. Get up from behind your computer and look out the window. There are a multitude of colors out there.
Let me try to explain it this way. You are entering information for a customer. When it comes to phone numbers do you assume everyone has a cell phone? What if someone does not have a cell phone? What do you do? What I am doing is asking a question: Do they have a cell phone? it is a yes or no. If yes, I have a pop-up to record the number. If the answer is no, I just move on to the next field to enter what ever that field is asking for. And continuing with my customer analogy, I know that only customers in certain cities have cell phones. So I only ask that question if the customer is from one of those cities. Or another way, Why would I ask you for information on what your motorcycle's license is if you only own a car?
We are not doing rocket science here. I am fulfilling a requirement that management wants. I am trying to do it in the easiest way for MY situation. What management does with the information I collect is their problem.
I am just a trained Electronics Tech that has been pressed into the role of Access developer. I am not some highly trained software developer that can dictate to the world how things should be done.
And for the record Mr. Hartman, It is attitudes like your "I know better than you so do it my way," that drive those of us trying to learn from the ground up away from this site.