How do I get data from a listbox?

[cowboy]

I have a list box with;
Name: lstPeople
Row Source: SELECT People.PID, People.[First Name], People.[Middle Initial], People.[Last Name] FROM People;



When I have an item selected in the list box I want to be able to push a button and get information from the selected person. This information is from the table People but the form I am on is unbound so I cant use current record or anything like that.

So for example I have the 4th person selected and click a button that will be able to display that persons PID

Thanks for any help

[pbaldy]

You can either use a technique like this to open a separate form:

BaldyWeb wherecondition

Or simply

Msgbox Me.ListboxName.Column(x)

where x is the column containing the desired info (zero based).