Help to autofill fields based on input in another field.

[Ambs]

Hello

I am fairly new to access, and have a problem that I cannot figure out.

I have a table called scrapped, in this the following fields are present
Name - Date - Department - category - Part number - Price - Vendor ID - Vendor name - COPQ - etc....

What I would like to do, is to have another table (Price information) where I have part numbers, prices, vendor ID and Vendor name typed in. Then when a part number is entered into the first table (scrapped) the information for price, vendor ID and vendor is automatically pulled from the table (price information). Is this possible?

Best regards,
André

[June7]

Select part number from a combobox. Set the combobox as multi-column with a RowSource query that pulls desired fields from Price table. Textboxes can reference combobox column by index to display related info. Index begins with 0.

=cbxPart.Column(1)

More details at http://www.baldyweb.com/Autofill.htm