Brenda,
Open your form in design view, open properties and go to the Other tab. Set
the Cycle property to Current Record. You then won't go to a new record when
you tab from the last field; you will just tab to the beginning again. To go
to a new record you will have to use the navigation button or do it with
code from a button you create.
Steve
"Brenda" <brenda@mycollegeinfo.com> wrote in message
news:4126338f$0$14463$c397aba@news.newsgroups.ws.. .[color=blue]
>
>
> I have an add page where I enter a new client. In doing this it assigns
> numbers to all of my sub pages. My question is on the form which only
> has three fields is it possible to stop it form scrolling to a second
> record. We have it setup that when you click the button it populates
> the tables and then deletes it from the add table. We would like it if
> only one client is able to be in the form at a time. I tried Allow
> Additions = No, but that does not work for obvious reasons. Any help
> would be appreciated.
>
> Thank you
> Brenda
>
> *** Sent via Developersdex
http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]
