Use lookup-functions to show the derived info. All very standard, no progamming required.
Kees
All,
I am attempting to design a standard Vendor Work Order form and I am wondering about the feasibility of what I would like the form to do.
I am wondering if it is possible to have an area of the form automatically populate with a vendor's information when that vendor is chosend from a drop down menu. In my case, I have 4-6 vendors. I would like when Vendor 1 is chosen, the field below it populates with vendor 1's contact info (address, phone, fax, email, etc). I also want to do the ame for the tech who is entering the info.
Is this even feasible? I have been playig around and I can only select one macro per drop down box. Also, when I run it, I get a debug error, but that may be moot given the feasibilty answer.
Thanks!
Brownie

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic