Auto Populate Form Fields Based on ComboBox Selection

[Moonman]

As a beginner to the Access and VBA world, I have created a form with three TextBoxes and a ComboBox. I would like to auto populate the three TextBoxes based on the selection in the ComboBox. All the data resides in one table. My db information is as follows:



Table Name: SystemTree
Column Name: X Description (TextBox X)
Column Name: XX Description (TextBox XX)
Column Name: XXX Description (TextBox XXX)

ComboBox Name: SSC

Any assistance of sample code would be greatly appreciated. I have searched the forum, and due to my lack of experience, I couldn't find anything that made it clear how to make this happen.

Thank you,

Moonman

[pbaldy]

How about:

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