By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

New Records

P: n/a


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!
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.