Item searches

[VooDoo]

Hi everyone i was just wondering if anyone new how to do the following;

Data is entered into a text box named txtItemNo on exit a search is performed and the next textbox txtDescription displays the results.

There is a table with itemnumber and item description in it the results would be the description.

Any ideas? This is on a subform, dont think this amkes any difference though
Thanks in advance

 

[ColinEssex]

Why not use a ComboBox? then you don't need the 2nd txtBox

Col

 

[VooDoo]

I really dont no why i didnt think of that???
Thanks its workin fine now