Stop Access 2003 from automatically filling in data.

[nlk]

I'm trying to find out why Access 2003 will auto fill my data entries. I've
noticed that when I put a number in a field that the next record will
automatically insert the next number in that field. For example, in my Order
column, in datasheet view, I enter a 1, the next record in the the Order
column will automatically fill with a 2 and so on. Or the pattern will
repeat - if I enter a 1 in the Order field, then a 3 in the next Order field,
the next Order field will fill with a 5. What is going on? and how do I stop
this?

 

[Duane Hookom]

You can't stop this "feature" when using a table datasheet view for entering
records. Use a form for entering and editing records.