var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Cannot go to next record or exit if there is missing value
In MS Access, Form
I want to set up that if there is missing value of the fields, then we cannot go to next record or exit the form when we click to do next action.
I tried to add the code in the After update event, or Exit event,
if (isnull([Zip]) or len([zip]) = 0) then
when I click to go to next record, or exit the form,
it give out message "missing", it work fines,
but, it still go to next record, or exit the form after the message.
How do I fix it? Thanks.
reading the help system 'ud be a pretty fine start.....