auto fill

[Art]

Hi, I am creating inventory tracking form. When entering a number in to a
field list box (Item number) I would like the filed list box (Items) to be
auto filled with the corresponding item name of that item, vise versa if I
enter a item name in to a list box (items) have it auto fill the field list
box (Item number). This way I need only know the item name or item number.



Thanks in advance

RT

 

[Guest]

Art, I have some code that does exactly that. Problem is, I don't have it
where I am today. If you can wait until Monday, and send me an E-mail
address, I will send it to you. It is Access2000, it is VBA code and the
listbox control. I can put them all in an mdb, zip it and send it to you. I
offer this, because it is more complex than I can explain here.