I have a table with a field, [Job Process].[JPGopher_ID], which requires a value in the field. The form I have developed for my users has the label, "By Whom" instead of [JPGopher_ID], which makes more sense for the users.
Unfortunately, the error msg that pops up (see attached .jpg) states "You must enter a value in the "Job Process.JPGopher_ID field", which doesn't mean anything to the users.
The 2nd attached .jpg, (Must_Enter_By_Whom_Value), is what my users see on the form.
Is there a way to change the MS Office generated error msg so it reads "You must enter a value in the 'By Whom' field?" which will make sense to my users?.
thank you.
Unfortunately, the error msg that pops up (see attached .jpg) states "You must enter a value in the "Job Process.JPGopher_ID field", which doesn't mean anything to the users.
The 2nd attached .jpg, (Must_Enter_By_Whom_Value), is what my users see on the form.
Is there a way to change the MS Office generated error msg so it reads "You must enter a value in the 'By Whom' field?" which will make sense to my users?.
thank you.