Prevent form from automatically moving to new record

[g_k_harrison@yahoo.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.

[Stuart McCall]

Re: Prevent form from automatically moving to new record

<g_k_harrison@y ahoo.comwrote in message
news:1bfec029-de31-4b8e-9cf5-8e50616dcce9@l4 2g2000hsc.googl egroups.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.

[fredg]

Re: Prevent form from automatically moving to new record

On Mon, 7 Apr 2008 16:22:27 -0700 (PDT), g_k_harrison@ya hoo.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