Autofill in Query

[Amanda]

Hello,

I have a user that refers to enter data into a query so that she can check
the calculations as she enters.

My question is as she enters data and goes from one record to the next
Access tries to fill in data which does not fit the criteria for that column.
For example if she enters 123 in record 1, then 124 in record 2, Access will
automatically fill in 125 in record 3 even though 125 is not an item in the
list for the look up wizard for that field, and then she receives an error.

Is there anyway to turn off this functions, so that Access will not
automatically insert the next sequential number?

 

[Stefan Hoffmann]

hi Amanda,

I have a user that refers to enter data into a query so that she can check
the calculations as she enters.

Don't do that. Create a form and set DefaultView to datasheet.

mfG
--> stefan <--

 

[Larry Daugherty]

IMHO users should not be fiddling with queries any more than they
should be messing around in the tables. Except for a few special
cases, Provide Forms as the only allowable means of entering and
massaging data.

HTH

 

[gary rand]

Hello,

I have a user that refers to enter data into a query so that she can check
the calculations as she enters.

My question is as she enters data and goes from one record to the next
Access tries to fill in data which does not fit the criteria for that
column.
For example if she enters 123 in record 1, then 124 in record 2, Access
will
automatically fill in 125 in record 3 even though 125 is not an item in
the
list for the look up wizard for that field, and then she receives an
error.

Is there anyway to turn off this functions, so that Access will not
automatically insert the next sequential number?

 

[LESLIE Emmanuel]

Im lost

 

[LESLIE Emmanuel]