Easy Combo Box Questions

[elephant97]

I hope this question isn't too novice, but I have a combo box on my Form that list Name,Address,City,State, and Zip. Each row of the combo box is a unique record. I would like (when the user selects a specific record from the combo box) the information to be listed in rows on the form. So, once selected, the record will look like:

Name
Address
City State Zip.


Thanks for the help!!!

 

[Revelation]

do you mean in a subform (the data displayed in rows). The way I would do it is, to make a select query where record = record youve selected, make a macro/code to refresh the form and display the query data in the form.

 

[elephant97]

How could I use a subform to achieve my result? I am currently not using any.