Pls show me an idea how to make a list box from which value selected will pull all related fields...
Thanks so much.

Make sure the 'Control Wizards' button is selected in your Toolbox (in Form Design mode). Place a new ListBox on your form, making sure to select the 'Find a record on my form based on the value I selected in my list box' radio button, click 'Next' and select the field(s) you wish displayed.

Shep