Auto Incrementing when entering data into a table

[Albion]

I have a table with two INT fields and a DATE field in a row that are linked from a MySQL database. When I enter '1' into the first field, and '3' into the second, it automatically puts 5 in the third when I tab to it. But because this is a date field it bombs out with a "The value you entered isn't valid for this field". I would like to turn off the functionality of this automatic incrementing, but either cannot find it or I'm completely missing the name of it.

Can someone help me out?

-Al

 

[lupins46]

If the table is linked to a mySQL source then the problem must be in the mySQL table definition mustn't it?

 

[Albion]

But this has happens to me when the table hasn't been linked from a MySQL source.

Create a table with 10 fields and open it. Enter 1 in the first field, hit tab, enter 2 in the second field, hit tab, WAHLA 3 shows up in the third field, hit tab again, and what do you think... there's 4 alright. And it keep autoincrementing the number by the series sequence forever. If you were to type 1 in the first field and 3 in the second, then hit tab, you'd get 5.

HOW in god's name do I turn this off? It's an MS Office annoyance, like Word turning "" into a smiley.

Thanks

-Craig

 

[lupins46]

Set the default value for each field to 0 (or anything)

 

[lespaul]

I'm sure there's some autocomplete setting that needs to be turned off. I would check in the options. I don't have Access on this machine, but that's my best guess!


Leslie

 

[hymn]

Dont Forget to Post the answer if you find, out trivial but annoying

Hope this helps
Hymn

 

[Albion]

I've looked through options and either I am getting the option name completely wrong or it's not in there. But, I will keep looking.

-Al