Turn off Auto Add in Access Form

Can some1 please show me how to turn of the auto-add in a access form.
You know how Access add the record to the "record source" table if you Tab (Enter) through the last text box (or any object) in a form.
I can set EnterKeyBehavior (of a text box) to default which take care off the Enter button, but I can't find anything for the Tab.

Any help is appreciated!!

Peace!

You could go to the form properties - Other and set the Cycle property to Current Record which would prevent going to a new record when a tab is pressed from the last field.


hope this helps

Thanks winterman, but I want to see all records.

I help a text field set up so that when users put in a "name", the code will build a query that pull in all records that match "name". Users then should be able to view all these records to pick out the only "name" that they really want based on other fields.

I can write more vba to handle that, but it's too much work.
There must be an easier way, the auto-add just really iritate me.