how do I update data on a form from a table

[Jon123]

I have a combo box pulling a partID from another table. Say part ID 50 how do I get the other fields to update on my form? Field1 = Field1 and field 2 = field 2 etc etc

 

[pbaldy]

Is this what you're after?

http://www.baldyweb.com/Autofill.htm