I have a name field whose values must be from a Name value list. ( ie Field validation set as member of value list.) This is fine as far as it goes, but when a user attempts to enter a value not on the value list you see a message with two buttons "Revert Field" or "OK". I have customised the message to make it slightly more intelligible but I am still left with the Revert button. ( This will totally flummox my users, who are not happy using computers at the best of times.) What I want to achieve is to cancel out of the layout currently being edited and take the user to a "Add New Name" layout. I assumed that with set error capture on I would be able to trap the relevant error and take things from there.
However getlasterror consistently shows 0 which isn't a great help. Does this field validation fail not produce an error code? If that is the case any alternative suggestions?