auto changing fields

[Rubius]

I have a query with an item field and a location field. Currently all the location fields are empty. I have it so that it prompts for an item name and it will display the item and the location field. now I need to make a list of misc items say &quot;WHEEL&quot; in the corrosponding location field. How can I make it so that after I type the item, it automatically fills in the location field with wheel?? and if possiable, just ask for the next item so that it will end up being me typing:<br>12 then enter<br>19 then enter<br>etc<br><br>and the table will look like<br>12&nbsp;&nbsp;wheel<br>13<br>14<br>19&nbsp;&nbsp;wheel<br>etc<br><br><br>thanks..hopefully you'll understand what I'm saying!

 

[DougP]

Not sure if I understand<br>if you type in 12 and press &quot;Enter&quot; then you want something to go look up 12 in a table which will return &quot;Wheel&quot; and return it where. To another text box on your form?<br><br>How come 13 and 14 do not have anyhing next to it in your example? What are they doing? <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.