tab creates a new record in my database

R

Rice

When the user tabs to the next textbox on my form it creates a new record.
How do I prevent this I only want a new record created from the form when the
user click on the command button I created.
 
A

Al Campagna

Rice,
Not much info to go on, but... it sounds like your tabbing out of the
current (just newly added) record, and into a New record.
In the properties for your Form, set the Cycle to Current Record.
That will keep you from tabbing out of the current record.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Top