Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Disabling new record add

Status
Not open for further replies.

pazgb

Programmer
Jun 9, 2003
60
US
Hello,

Hopefully someone has a simple answer to this.

I am using a form to add a new record. I only want the user to be able to enter 1 record and no more per form page.

Im having problems, I disabled the navigation buttons and if you tab all the way through all fields it goes to the next autonumber record. How can I stop this?

I still want them to be able to add just 1 and only just 1.

Thanks,
Mike
 
Have a look to the Cycle property of the form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Thanks You are the man.

I set the cycle property "Current Record" and works like a charm!

Have a good day!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top