New Records

[Brenda]

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!

[Steve]

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" <br****@mycollegeinfo.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

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!