Paramter Query using a list box

[euanhampton]

Hi, Anyone got any ideas how I can create a query that runs from the selection in a list box. What I need to do is when the user selects an option in the List box for them to select a button to the right which acknowledges the secletion and then runs a query with the selection as the criteria.

Any ideas???

euan Hampton

 

[neileg]

You need to use the value of the control as the parameter in the query. It will look like this:
[Forms]![MyForm]![MyControl]

You need to ensure the form is still open when the query runs.

 

[euanhampton]

Hi, thanks for this..

So my form is called "Query of Watercourse"
so in the criteria in the Query all I have to type is [Forms]![Query of Watercourse]![MyControl] ??? or where do i get the control from.

Sorry about this

 

[Dennisk]

the control referred to here is the name of your combo box