Hi Folks,
In a form linked to SQL table with mandatory fields, if someone doesn't enter all the mandatory fields then hits a command button that sends them back to the main form, after closing the input form, a ODBC--call failed error appears stating column does not allow nulls ... is there a way to simply turn this error off and instead just send some sort of undo command when this occurs, so that the main menu comes up after the input form closes without the user getting a message saying record cannot be saved? I assume that if a user starts to enter data but not all the mandatory fields then wants to go back to the main form, it means they don't intend to save the record so I am trying to not have that ODBC prompt come up when that occurs and only if they try to save the record.
Thanks for any assistance you can provide,
Joe
In a form linked to SQL table with mandatory fields, if someone doesn't enter all the mandatory fields then hits a command button that sends them back to the main form, after closing the input form, a ODBC--call failed error appears stating column does not allow nulls ... is there a way to simply turn this error off and instead just send some sort of undo command when this occurs, so that the main menu comes up after the input form closes without the user getting a message saying record cannot be saved? I assume that if a user starts to enter data but not all the mandatory fields then wants to go back to the main form, it means they don't intend to save the record so I am trying to not have that ODBC prompt come up when that occurs and only if they try to save the record.
Thanks for any assistance you can provide,
Joe
