How to use a wildcard in a form

[simonwerner]

Hello,

I have a query that has the selection referencing a form text label. For example, in the query critera box I have

[Forms]![Frm_Development]![selectedMonth]

This works find if I want to make only one selection in the field. However if I put a "*" (minus the quotation marks) in the form text label it will interprete the star as a string. How do I get the query to interprete the star as a wildcard?

thanks for you help,
Si

 

[Blorf]

Try changing your query to say

like [Forms]![Frm_Development]![selectedMonth]

instead of =[Forms]![Frm_Development]![selectedMonth]

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[simonwerner]

That did the trick, thanks for the tip ChaZ.

Si