I have a tab control in a form for entering new records.
I want to restrict the user from leaving a page unless
they have filled in the controls. What is the easiest
method to do this?

I'm trying to use the Autonumber control to test it but
cant figure out what to do.

Hi,


Cancel the Before Update (sub)form event. Since the record could not be
save, you will still be in the same record, same (sub)form, same page.


Hoping it may help
Vanderghast, Access MVP


"Patrick GRaham" <(E-Mail Removed)> wrote in message
news:2855f01c390f3$e2827900$(E-Mail Removed)...
> I have a tab control in a form for entering new records.
> I want to restrict the user from leaving a page unless
> they have filled in the controls. What is the easiest
> method to do this?
>
> I'm trying to use the Autonumber control to test it but
> cant figure out what to do.
>