Selection or All

[RussG]

I need to be able to run a query for Individual venues or All venues. I have a combo box on a form to make my Venue selection which is referenced by the query using Forms!frmMyForm!cboBox1. How can I run the query for All venues, other than setting up a new query.

Any help gratefully received.

Russ

 

[Alexandre]

Change the criteria in your query to:
Like Nz(Forms!frmMyForm!cboBox1,"*")

This will return all records if the combo is left blank

Alex

 

[RussG]

Many thanks Alex, I have wonderd about that one for quite some time.

 

[GJC]

I have a similar problem, I copied the exact string as suggested but now when I select something from my dropdown I still get prompted for a value in the field. It does not appear to be recognising the "picked" data

 

[Alexandre]

You have to adapt the exxample to your particular case:
Forms!NameOfYourForm!NameOfYourComboBox

Alex

 

[Pat Hartman]

Your relational operator needs to be "Like" rather than "=" for the asterisk to work.

 

[GJC]

I had changed the names of the table to refect my form etc. It the query is not picking up any values I am putting in, just the wildcard *. Would it be in any of the properties settings ?

Sorry but I am quite new to all this

G

 

[Alexandre]

Let us see the SQL. Check whether when you run the query, your control is not empty. Check if the syntac you use to reference your control is correct.

Alex