Stop Auto Fill

[widge]

I have created a table and from that I have created a query so I can select
a record and input a stock amount for the record. When I open the Query
datasheet and type in the stock code the field is being populated by the
first record beging with for example AJ when I may want to find the record
AN111 is there any way I can stop the field being populated and allow me to
enter the stock code I require.
Thanks
Widge

 

[Arvin Meyer [MVP]]

Any data entered in the datasheet is part of a record, If you simply want to
find a record, use a form with an unbound search combobox. If you must use a
query (and be aware that you take the chance of accidentally
editing/deleting/or otherwise destroying data) use the criteria box in the
query's design view to force searching the field. Something like this should
work:

[Enter the stock code to search for]

Access with then prompt for the search criteria. You van get a good tutorial
on this and other database techniques at:

http://www.accessmvp.com/Strive4Peace/Index.htm