WildCard

[Mike]

Hello
i have a form which contains some Combo boxes. for each of
these combo boxes i have manually entered the data that
will appear. i have a query where the criteria are the
entries selected in the combo boxes.what i need to do is
also add a wildcard entry in the combo box so the user can
either select one of the entries i put in, or by selecting
the wildcard can extract all data. does anyone know how i
can add a wildcard entry in the combobox so that all data
is extracted by the query. i tried * and *.* but neither
worked.
thanks for any suggestions, Mike

 

[Chris Large]

In order to use a wildcard you will have to use 'like' in
the query. So in the query the criteria will be:-

like [Forms]![YourFormName]![YourComboBoxName]

If the combobox contains *, this will return all records.

hth

Chris

 

[Mike]

Thanks Chris, that worked perfectly

-----Original Message-----
In order to use a wildcard you will have to use 'like' in
the query. So in the query the criteria will be:-

like [Forms]![YourFormName]![YourComboBoxName]

If the combobox contains *, this will return all records.

hth

Chris

-----Original Message-----
Hello
i have a form which contains some Combo boxes. for each of
these combo boxes i have manually entered the data that
will appear. i have a query where the criteria are the
entries selected in the combo boxes.what i need to do is
also add a wildcard entry in the combo box so the user can
either select one of the entries i put in, or by selecting
the wildcard can extract all data. does anyone know how i
can add a wildcard entry in the combobox so that all data
is extracted by the query. i tried * and *.* but neither
worked.
thanks for any suggestions, Mike

.

.