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.

<g_k_harrison [at] yahoo.com> wrote in message
news:1bfec029-de31-4b8e-9cf5-8e50616dcce9 [at] 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.

On Mon, 7 Apr 2008 16:22:27 -0700 (PDT), g_k_harrison [at] 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