Prevent form from automatically moving to new record

Hello, again. What a great resource for us beginners is this forum!
I've got another question...Even though the record selectors and
navigation buttons are removed from a form you can still advance to
the next record in a table after the last field is filled. Does anyone
have a method for preventing that happening? Maybe some way to send
the focus back to the first field on the form on the same record?

Many thanks for your help!
Greg.

Re: Prevent form from automatically moving to new record

wrote in message
news:1bfec029-de31-4b8e-9cf5-8e50616dcce9@l42g2000hsc.google groups.com...
> Hello, again. What a great resource for us beginners is this forum!
> I've got another question...Even though the record selectors and
> navigation buttons are removed from a form you can still advance to
> the next record in a table after the last field is filled. Does anyone
> have a method for preventing that happening? Maybe some way to send
> the focus back to the first field on the form on the same record?
>
> Many thanks for your help!
> Greg.

In the property sheet for thr form, set the 'AllowAdditions' property to No.

Re: Prevent form from automatically moving to new record

On Mon, 7 Apr 2008 16:22:27 -0700 (PDT), g_k_harrison@yahoo.com wrote:

> Hello, again. What a great resource for us beginners is this forum!
> I've got another question...Even though the record selectors and
> navigation buttons are removed from a form you can still advance to
> the next record in a table after the last field is filled. Does anyone
> have a method for preventing that happening? Maybe some way to send
> the focus back to the first field on the form on the same record?
>
> Many thanks for your help!
> Greg.

Set the Form's Cycle property to
Current Record
It's on the Form property sheet's Other tab.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail