Auto filled cells

[Guest]

I am entering data intot eh Access spreadsheet. Any time two columns begin a
series, Access auto fills the next number. If col1=2 and col2=3 it puts a
"4" into col3. Same if first col=2 and next col=4 it pusta "6" in the third
col. Often, they are values that are not allowed and i keep getting error
messages. Is there any way to turn off this automatic filling of cells?

 

[Guest]

Access does not use spreadsheets. Excel uses spreadsheets. Access uses
tables, queries, forms.

When you are using a table to input data, it will sometimes exhibit this
behavior, which is an unfortunate coding decision associated with Microsoft
Office. You should not be using a table or query to input data. You should
be using forms to input data, and then you will not see this happening.