Autofill in Query

  • Thread starter Thread starter Amanda
  • Start date Start date
A

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?
 
hi Amanda,
I have a user that refers to enter data into a query so that she can check
the calculations as she enters.
Click to expand...
Don't do that. Create a form and set DefaultView to datasheet.

mfG
--> stefan <--
 
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
 
Amanda said:
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?
Click to expand...
 
Back
Top