Debra Dalgleish has some web pages on this subject.

For the drop down:

http://www.contextures.com/xlDataVal01.html

And for the subsequent matching fields:

http://www.contextures.com/xlFunctions02.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"zemie25" wrote in message
...
I am trying to create a form in which 2 columns of information are linked.
In
one column is a product number and the other is a product description. I
want
the form to have drop downs if possible. I want the result to be if you
select the item number the description column fills in or vice versa. I
would
also like this information to come from a database containing all the
product
item numbers and descriptions.