invoice creation problem

[spags123]

hi everyone. I have been trying to figure out a solution to this problem for months. I am trying to build an invoice. I would like to punch in a products number and have the next column product description be populated. then i would add the quantity, unit (case) or (each) or (pounds) and have the units price be populated. I think I need a dlookup to the products table, but I just can't. envision it... any suggestions would be most appreciated.

[pbaldy]

You can use a combo and this technique:

http://www.baldyweb.com/Autofill.htm