How to use a dropdown value an use that data in a query?

[endacoz]

I have a database of people and items associated with them. I am working on a form that has as listbox of all the names of the poeple, 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

**Email removed in accordance with site rules**

[Rabbit]

In the query use Forms![Name of Form]![Name of Combobox]

[endacoz]

In the query use Forms![Name of Form]![Name of Combobox]

I am not getting that to work. I am using a dropdown list box. Will that make it different? is there a way to index what is selected in the listbox?

Ethan

[Rabbit]

I am not getting that to work. I am using a dropdown list box. Will that make it different? is there a way to index what is selected in the listbox?

Ethan

What is the SQL of the query?

[endacoz]

What is the SQL of the query?

SELECT Writers.Writers, Writers.[Writers ID], Writers.[Writer Information], Apperance.[Apperance ID], Apperance.Description, Apperance.Date
FROM Writers INNER JOIN Apperance ON Writers.[Writers ID] = Apperance.[Writers ID]
WHERE (((Writers.Writers) Like [Forms]![FindWriter]![List6]));

I appreciate you taking the time to help

Ethan Cook

[Rabbit]

SELECT Writers.Writers, Writers.[Writers ID], Writers.[Writer Information], Apperance.[Apperance ID], Apperance.Description, Apperance.Date
FROM Writers INNER JOIN Apperance ON Writers.[Writers ID] = Apperance.[Writers ID]
WHERE (((Writers.Writers) Like [Forms]![FindWriter]![List6]));

I appreciate you taking the time to help

Ethan Cook

Are you using Like because you're doing a substring search? If so then it should be

Like "*" & [Forms]![FindWriter]![List6] & "*"

Is the listbox bound on the correct field?

The problem might be because the table name and the field name is the same but I doubt that's the problem.