i want to use a control that can display certain
data from my sql7 server
my SQL query is
"select firstname,surname,details from people where
personid =" & personvariable

i want it to display the firstname and surname,details
using a control that is dependant on my variable called personid
ie
so if i have a listbox control with 100 names and surnames
in it and i select one persons name it picks up my varible assigned to that person called personvariable and assignes that value to my personID which is used to pick up all the information a on that person and display it in my control
ie datacontrol until i select another person!!!
help me please
i have tried using a datagrid control with a data control
but my query stuffs it up cause it does not pick up my variable!!!

please respond ASAP im having real difficultys to get this going!!