Populating a form from value chosen in a combo box

[Roop Kada]

I am using Access 2007 and trying to populate couple of fields on a form based on a value selected from a combo box.

Ex: I choose customer name in the combo box and the related data (ex: address, state, zipcode, etc) for that particular customer needs to be populated on the form.

Any help is greatly appreciated. I searched through couple of solutions and am looking for the best.

Thanks,
RA

[NeoPa]

Your question is about filtering (even if you weren't aware of it :-D). See Example Filtering on a Form for help with this.