Choice in combo box determines other field

[Guest]

Still pretty new to Access, not sure what I'm doing wrong...

I'm working on a database to track quotes, and I'm having trouble with my
Add New Quote form, here's what I've got:

Tables
Parts - fields PartNumber and Description
Quotes - fields Vendor Name, Date, Price, Quantity

My PartNumber field is a combo box because on my Add New Quote form, I want
the user to be able to choose a PartNumber from the list. How do I get my
Description field to autofill with the correct Description when a PartNumber
is chosen from the combo box?

Thanks

 

[Ken Snell \(MVP\)]

See this article at The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm