Is it possible to create a list from a table containing personnel forenames and surnames, and display it in a form as a list so that a user can highlight that particular personnel and then click on a command button which would open a form only relating the the personnel highlighted.
I can do this using combo boxes, but I wanted to show a list as the form opens

have you considered using a continuous subform to do this?

hth,
al

I can not use a subform, as I want the list as part of the main form.
I want to know how to hightlight a person in the list and click on a command button, the new form will open ref the person ID that is highlighted

Have a look at the "Solutions" sample database supplied by MS. There are examples of working with list boxes.

hmmm, well a subform is arguably part of the main form.

and unlike, a combo box, it will display all records when the main form opens. further, you can put the command button right on the subform at the end of the records to open your other form.

when you look at the 'Solutions' sample, you might also want to look at some of the subform samples.

al


[This message has been edited by pcs (edited 12-15-2001).]

Where do I find the "solutions" sample database

If you created your combo using the wizard, you will feel familiar if you use the List Box wizard.

The value of the list box will be that row selected in your list box. Your command button can run to open form that matches the value of the list box. Use the wizard again to create the command button.