Newbie: pass selected combo-box value to variable

[sysadmin101]

when the user selects a value from a combo-box, the form displays the ID i.e. the auto-increment serial of the table I read into the combo-box.

I would like to be able to display more than this for the user; my first idea is to catch that value and then run an SQL SELECT on the table and display some fields.
Is this the best approach for an MS Access data entry form?

 

[pbaldy]

Like this?

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