Is there a way to auto fill fields? Here's what I mean. I have a table that contains a vendor number, the name of the vendor, the address, and the state. I have a combo box to drop down to show the vendor numbers to select from when filling out the form. I want to automaticallly have the name, address, and state fields automatically filled in when I select a certain vendor number.
Is this possible?

Thanks

Mike