How do you take the value of a dropdown list and put in into a query?

[endacoz]

I have a database (access) of people and items associated with them. I am working on a form that has as listbox of all the names of the people, select the person you want and then click the button and it should run the query with the selected value from the listbox into the query? At the moment when i hit the button my query runs and returns all the people.... how do i get the selected value to be passed into the query?

Thanks

Ethan

[devonknows]

I have a database (access) of people and items associated with them. I am working on a form that has as listbox of all the names of the people, select the person you want and then click the button and it should run the query with the selected value from the listbox into the query? At the moment when i hit the button my query runs and returns all the people.... how do i get the selected value to be passed into the query?

Thanks

Ethan

I believe you mean something along the lines of a drop down that has a list of options like Male/Female... i believe something like this.

Dim sqlStr as String
If Not DropDown.Listindex = -1 Then
    'ListIndex + 1 Because the Listindex Starts from 0 Where as the List Starts From 1
    sqlStr = "SELECT * FROM MyDataBaseName WHERE Gender='" & DropDown.List(DropDown.ListIndex + 1) & _ 
             "' ORDER BY Gender"
 
    'Execute your sqlString ... 
End If
 

Hope This Helps
Kind Regards
Devon